how do I add information from many worksheets to one main workshee

Z

Zack Barresse

Hello,

Without knowing how your data structure is setup, it's fairly difficult to
know what you are dealing with and provide you with a specific answer. But
you can use formulas to bring in data from other sheets ...

=Sheet1!A1
=Sheet2!A2
=Sheet3!A3
... etc.

HTH
 
P

Paul Sheppard

With Links,

In whatever cell in the main sheet you want to start listing the dat
type =, then go to the first cell in the worksheet that you want t
copy the data from and click on it, then Enter

You will now have a link between the 2 worksheets, that looks somethin
like this

=WorksheetName!$A$1

The new worksheet will automatically update when you alter th
original

To get links to the other cells in the work book, remove the $ sign
from the formula and click and drag it as far as you need

Pau
 
Top