Automatic amalgamation
 

I have a document with several worksheets, each one containing data from
a specific geographic area. I also have one worksheet that contains all
of the data from every other worksheet - a master worksheet
representing all of the areas. Currently whenever I update one of the
area worksheets I have to manually copy the new information onto the
master worksheet. Is there a way for this master worksheet to
automatically update every time I add new information into any of the
area worksheets?


--
Spreadsheet
------------------------------------------------------------------------
Spreadsheet's Profile: http://www.excelforum.com/member.php...o&userid=34730
View this thread: http://www.excelforum.com/showthread...hreadid=545328

Automatic amalgamation
 

All you have to do is make reference to the cell on the second sheet that you
wish to collect data for. For example:
if you have data on sheet "Area1" in cell A1 and want it on your master
sheet in a specific cell, click on that cell and type in =Area1!A1

HTH
Tom

"Spreadsheet" wrote:


I have a document with several worksheets, each one containing data from
a specific geographic area. I also have one worksheet that contains all
of the data from every other worksheet - a master worksheet
representing all of the areas. Currently whenever I update one of the
area worksheets I have to manually copy the new information onto the
master worksheet. Is there a way for this master worksheet to
automatically update every time I add new information into any of the
area worksheets?


--
Spreadsheet
------------------------------------------------------------------------
Spreadsheet's Profile: http://www.excelforum.com/member.php...o&userid=34730
View this thread: http://www.excelforum.com/showthread...hreadid=545328

Automatic amalgamation
 

Tom,

The reason that I did not think that your suggestions would work for my
spreadsheet is that I need the master worksheet to be sorted
automatically. If I let a cell on the master sheet =Area1!A10, which
currently is empty, when I sort the data on the master sheet, the
blanks go to the top. Furthermore, when I do enter data into Area1!A10,
it remains among the blank cells at the top, whereas I want it to be
automatically sorted to its rightful place in the master worksheet. Any
suggestions?


--
Spreadsheet
------------------------------------------------------------------------
Spreadsheet's Profile: http://www.excelforum.com/member.php...o&userid=34730
View this thread: http://www.excelforum.com/showthread...hreadid=545328