User Profile
sebastian358
Copper Contributor
Joined Aug 11, 2023
User Widgets
Recent Discussions
Re: indexing formula not updating its reference automatically
nimesht so there is one sheet that I manually create and then I have a macro that copies that sheet into several other workbooks, the work books consist of two sheets the first sheet is the sheet that has the info boxes in it, the second sheet is the data sheet that the macro updates, the indexing formula is in the first sheet of the workbook (one in each box that displays data) when the macro is run from the original workbook to update the other workbooks it copies the data fine. (This process copies cells opens another workbook and then pastes and closes the workbook) however when I then open one of the now updates workbooks I have to re reference the indexing formula as if I don’t the data won’t show up on the first sheet, the data in the first sheet references the second sheet all inside the same workbook.2.3KViews0likes0CommentsRe: indexing formula not updating its reference automatically
nimesht hi Nimesht Yes they are set to automatic also f9 only refreshes the sheet it doesn’t refresh the references. The formula is an indexing formula that uses the active cell and match’s that cells data with data on the second sheet, it then shows data from that row to get the formula to work you have to select the cell and then press f9 to refresh the data. The problem I’m encountering is when I update the data on the second sheet with more entries/ updates to the existing data I have to then re reference the sheet each time, however thank you for your response I appreciate you taking the time. kind regards2.6KViews0likes2Commentsindexing formula not updating its reference automatically
hi, I have an excel sheet that uses an indexing formula to find info on the second sheet of the workbook. this second sheet is updated every so often by using another macro from another workbook. when I use the updating macro it copies info from 1 sheet into several others by opening them unprotecting them copy and past info then re protecting them and finally closing them. the copy and paste works fine, but when you then go into the sheet and try and look at the new data, it doesn't show up in the indexing formula even though it is physically there on the second sheet. I have to go into the formula and press enter, it then brings up the file finder and I have to reselect the sheet each time. my question being is there a way to get the sheet to automatically re-reference the sheet after an update? or do I have to manually open and re reference every sheet each time there is an update.3KViews0likes4Comments
Recent Blog Articles
No content to show