Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

General discussion

Linking excel sheets to a summary page

Nov 1, 2007 7:52AM PDT

I need to link excel sheets to a summary page, but I'm not sure how to do this. I checked with the help feature, and also searched online, but I'm not getting much help.


Does this basically act as a cover sheet, but include data from within the actual excel sheet?

For example, if I were to do a project that included a persons name, their time spent and money spent, would these three values be listed on that sheet? If so, how would I go about doing that?


If there is a link to instructions, that works as well, but I was unable to find anything.


Thanks so much!

Discussion is locked

- Collapse -
Re: Linking excel sheets to a summary page
Nov 1, 2007 8:01AM PDT

" For example, if I were to do a project that included a persons name, their time spent and money spent, would these three values be listed on that sheet? If so, how would I go about doing that"

Lets suppose you had a spreadsheet with 4 pages or tabs, called Summary, Andy, Brian and Charles.

On the tab called Andy, money spent is in cell H27. On the summary tab, you want to see Andy's money spent in cell D3

You click in cell D3 on the summary page, type an equals sign, click on the tab Andy at the bottom of the workbook, click cell H27 and press enter.

Hope this helps

Robert

- Collapse -
Try...
Nov 1, 2007 10:17AM PDT

On the summary page, the formluae to reference to Andy's money spend is =Andy!H27. i.e. type =Andy!H27 at the cell D3 on the summary page.

- Collapse -
(NT) (Reply intended for Ms.Gadgettes )
Nov 1, 2007 10:19AM PDT
- Collapse -
That's easy enough
Nov 1, 2007 10:41AM PDT

I think I've done this in the past, but forgot about.


Thanks so much for your help, I really appreciate it!!!