| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Rollup worksheets into a master worksheet - automatically?
You say that all column headers are the same so it would be feasable to pull
in similar cells in each workbook based on the same cell co-ordinates but in different workbooks i.e. ='[Cathy.xls]Sheet1'!$D$4+'[Laura.xls]Sheet1'!$D$4+'[Tonya.xls]Sheet1'!$D$4 etc "Ann" wrote: Thanks for your feedback. Yes, four workbooks could be employed, but I still need to pull the information into the master worksheet. Do you know of a formula or macro to accomplish this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| automatically appending newly added data on worksheet to a master list worksheet | Links and Linking in Excel | |||
| Automatically copy from Master worksheet to others | Excel Worksheet Functions | |||
| Automatically updating worksheets from a master worksheet | Excel Worksheet Functions | |||
| Master worksheet automatically enters data into sub worksheets | Excel Discussion (Misc queries) | |||
| Rollup worksheets into a master worksheet - automatically? | Excel Discussion (Misc queries) | |||
Threaded Mode
