Donate SIGN UP

Excel Function

Avatar Image
EvianBaby | 16:31 Fri 24th May 2013 | Technology
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?
Gravatar

Answers

Only 1 answerrss feed

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 answerrss feed

Do you know the answer?

Excel Function

Answer Question >>