displaying content from multple tab

February 12, 2009 at 12:58:59
Specs: Windows XP
Is there a way to display content from multiple excel tabs all on one tab? I'm not looking to do any calculations, but am looking to for different people to be able to update specific tabs and then then have all of their informaton display on one main tab. Thanks in advance.

See More: displaying content from multple tab

Report •

February 12, 2009 at 14:35:39
You mean sheets... Did you look in Help? I found this:

Open the workbooks you want to view.
To view multiple sheets in the active workbook, click New Window on the Window menu. Switch to the new window, and then click a sheet you want to view. Repeat for each sheet you want to view.

On the Window menu, click Arrange.
Under Arrange, click the option you want.
To view sheets in only the active workbook, select the Windows of active workbook check box.

"So won’t you give this man his wings
What a shame
To have to beg you to see
We’re not all the same
What a shame" - Shinedown

Report •

February 12, 2009 at 21:06:13
If you want to display all the data from multiple sheets on one sheet, you would have to dedicate sections of the main sheet for each sheet and then use formulae like:

=Sheet2!A1 =Sheet2!B1
=Sheet2!A2 =Sheet2!B2


Obviously, any given cell can only display the contents of a single cell from another sheet, so the main sheet could get pretty big if there is a lot of data in the other sheets.

Report •

Related Solutions

Ask Question