Question on Referencing

[Guest]

Hi,

I have an Excel file containing 10 worksheets. One (Sheet 10) of the 10
worksheets is used to pull the data from other 9 worksheets that users key
in. At the end, Sheet 10 will have about 1000 records from the other 9
sheets.

Instead of linking the cells to Sheet 10 from other 9 sheets, what would be
the best way to pull the data from other 9 sheets? Would the "Name" feature
work? How about "Label"? Any other recommendation besides "Name" and
"Label"?

Thanks.

 

[Guest]

Not sure if this helps but here is a consolidation routine...

http://www.rondebruin.nl/summary.htm

 

[Guest]

Good morning Jim,

Thanks for the information. It would be nice to have a code to pull the
data from 9 worksheets. After I have reviewed the code, I was wondering how
the code knows which data to pull.

The way 9 worksheets set up is not straight forward. Besides the data that
we want to pull, there are information in those 9 worksheets. For example,
Worksheet 1 is set up the way the IRS tax form 1040. From Worksheet 1, we
want to pull the data on incomes, adjustments, deductions and credits that
users key in. Therefore, the data are everywhere in each sheet.

Thanks.