Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatic and manual calculations | Excel Discussion (Misc queries) | |||
enable automatic refresh | Excel Worksheet Functions | |||
Please help with adding automatic data. | Excel Discussion (Misc queries) | |||
options to update automatic links | Excel Worksheet Functions | |||
How can I find automatic links in an Excel-sheet? | Excel Discussion (Misc queries) |