ChatterBank2 mins ago
Excel Function
1 Answers
Another excel query.
I have a spreadsheet with various tabs. There is on tab that contains the info from all other tabs. What I want to happen is that when I change some info in the full list tab, it automatically updates the info for that row in the other tab relevant for that item.
Is Vlookup the function I want? Or is there a better/easier way?
I have a spreadsheet with various tabs. There is on tab that contains the info from all other tabs. What I want to happen is that when I change some info in the full list tab, it automatically updates the info for that row in the other tab relevant for that item.
Is Vlookup the function I want? Or is there a better/easier way?
Answers
Only 1 answer
Best Answer
No best answer has yet been selected by EvianBaby. Once a best answer has been selected, it will be shown here.
For more on marking an answer as the "Best Answer", please visit our FAQ.
If you can give us an idea of the type of data and how it's calculated in the full list, then it'll be easier to give a more comprehensive answer. It could be a case of simply just referring to the cells in the full list, e.g. =Sheet1!A1:G1 will copy the first 7 cells in row 1 of "Sheet1" to any other worksheet.
Only 1 answer
