Needs some quick excel help from a cubicle guru.

[thespeakerbox]

I have about 10 sheets in a workbook (for example purposes consider them sheets A,B,C, etc.). Within each sheet is a list , say about 4 or 5 items with a description and price fields. So in each sheet items A1-A5 are filled. This data chages regularly.

I need to make a summary sheet. I would like the info A1-A5 for each sheet to show on this summary page. The idea that when I change the sheets individually , the summary will automatically change.

How can i do this in excel?

 

[hydroponik]

Couldn't you just make another sheet tab, and put totaling formulas on the last sheet tab to reflect the data sheet tabs? Unless I am not understanding correctly.

 

[dullard]

(1) Create the summary sheet.
(2) Click where you want the summary.
(3) Hit the equals (=) sign.
(4) Click on the data sheet.
(5) Click on Cell A1.
(6) Press Enter.
(7) Copy that new cell.
(8) Paste that new cell into four cells below it.
(9) Rinse and repeat with all data sheets.

 

[ryan256]

Place the following inside the cells of the summary sheet.
=<sheetname>!$<column>$<row>

Example "=Sheet2!$E$14" will take the data from cell E14 on Sheet2 and place it in the cell you typed that into.

 

[amish]

use vlookup.

in the summary sheet have the descriptions listed then use vlookup to grab the data from each sheet.
it will look something like this.
=vlookup("description",sheet2!a1:F3,2,false)

that way it looks at the description that you have in the summary, looks for it in the other sheets, finds the amount next to it, and pastes it into your summary.

 

[thirtythree]

I think this is what you're asking:

1. Select the content you want from one of the previous sheets.
2. Copy.
3. Go to summary sheet and right click > Paste Special.
4. Click "Paste Link" in the bottom left.

When you update anything in the original sheets, it will then update the summary sheet.

EDIT: Heh, had this thread unrefreshed then replied. I see several people beat me to it, though I still think my solution is easiest.

 

[thespeakerbox]

Originally posted by: thirtythree
I think this is what you're asking:

1. Select the content you want from one of the previous sheets.
2. Copy.
3. Go to summary sheet and right click > Paste Special.
4. Click "Paste Link" in the bottom left.

When you update anything in the original sheets, it will then update the summary sheet.

EDIT: Heh, had this thread unrefreshed then replied. I see several people beat me to it, though I still think my solution is easiest.

Thanks . Worked like a charm.