Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Creating a master worksheet
I have several worksheets that I would like to combine the data from onto one
worksheet. Is this possible and if so, how do I make it work? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Creating a master worksheet
This works, but is there a quicker way to put the data onto a master sheet?
I have to change the formula at each cell and then do the update value after each cell. I have over 15 worksheets in the workbook that go from A2 to V2 with sign up information. Thanks for your help! "Gilbert De Ceulaer" wrote: if you want the value of a1 of SHEET1 of WORKBOOK1 then put ='[WORKBOOK1.xls]SHEET1'!$A$1) you could make this very easy to change (the names of the workbook, or the name of the worksheet) by putting "WORKBOOK1" in a1 of your destination-sheet and "SHEET1" in a2 in your destination-sheet then the formula would be =INDIRECT("'"&A1&"'!"&A2) if you want an error-trap (in case A1 or A2 does contains wrong data) the formula becomes =IF(ISERROR(INDIRECT("'"&A1&"'!"&A2)); "something is wrong !"; INDIRECT("'"&A1&"'!"&A2)) does this help you ? GDC "lrobin65" wrote in message ... I have several worksheets that I would like to combine the data from onto one worksheet. Is this possible and if so, how do I make it work? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Master Worksheet reflecting sub-worksheets | New Users to Excel | |||
One worksheet to calulate different items simultaneously | Excel Worksheet Functions | |||
access my data from my master worksheet while calculation is don. | Excel Worksheet Functions | |||
how do i link a number of worksheets to one master worksheet? | Excel Worksheet Functions | |||
Weekly Transaction Processing | Excel Worksheet Functions |