Multiple sheet data summary

G

Guest

I am trying to do something I think is simple, but can't get it...
I am building a worksheet in which I would like to list data from the same
cell of each of the preceding worksheets. For example, each sheet represents
a salesperson and cell A1 of each sheet has sales figures for that person. I
would like to make a list in column A of a summary sheet to return each
figure in a list. Any help would be greatly appreciated!
 
B

Bernard Liengme

The simple formulas would be:
=Sheet1!A1
=Sheet2!A1
If the sheets have other names, change as needed.
If typing lots of formulas is a problem: tell as the sheet names and maybe
an INDIRECT formula can be devised.
best wishes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Spreadsheet summary automatically referrences totals of worksheets 2
Copy summary data to new sheet 1
auto fill certain data from sheet1 to sheet 2 2
Linking to other worksheets 3
Copying data to summary sheet 2
Copying Cell from Multiple Worksheets to a Summary Worksheet 4
summary values across worksheets within the same workbook 2
Referencing Cells in a Summary page 5

Top