Help with referencing...

[Guest]

I have to create an Excel book. The 1st page will be the collective data. The other pages will have individual information. I'll have perhaps 10 pages. Each page will have how many trips an individual runs. I need to know how to make each page refer back to the main page, so that when I update one of these 10 pages it will automatically update the 1st page. Can you please give me the example, I am a beginner

Can someone help me?

Thanks so much

 

[Peo Sjoblom]

From the first sheet you have to link to the other sheets, you do that by
entering an equal sign in the particular cell you want for this
particular sheet, then you click the sheet tab of the sheet you want to link
to, then you click the cell and press enter
Note that I replaced page with sheet assuming it is that what you want to do

--

Regards,

Peo Sjoblom

I have to create an Excel book. The 1st page will be the collective data.

The other pages will have individual information. I'll have perhaps 10
pages. Each page will have how many trips an individual runs. I need to know
how to make each page refer back to the main page, so that when I update one
of these 10 pages it will automatically update the 1st page. Can you please
give me the example, I am a beginner.

 

[Guest]

Thank you so much. I will try this

Sandy