Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Linking 3 closed worksheets to master workbook template
How can open my master template workbook and have the information from 3
separate workbook sheets load into my master workbook. I have three Reports that I poll everyday with Crystal Reports. These 3 reports are then exported into excel as 3 separate workbook sheets. I now have them linked to my master template workbook with special paste links. Problem is that I have to have all 4 books open for the information to update in master book. I need it to just automatically link the information or copy the sheets over to mastertemplate daily. How can this be achieved? The needs to be a simplier way to do this. To had to try my staff. Too many different reports to work with. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Linking 3 closed worksheets to master workbook template
My approach would be to go after the data with Excel and MSQuery insetad of
Crystal Reports, this, under macro control could put the three source datas in 3 sheets within the one Excel workbook, and the Master sheet could be the fourth sheet and all the data linked to it.........only one Excel file involved. hth Vaya con Dios, Chuck, CABGx3 "fabiano" wrote: How can open my master template workbook and have the information from 3 separate workbook sheets load into my master workbook. I have three Reports that I poll everyday with Crystal Reports. These 3 reports are then exported into excel as 3 separate workbook sheets. I now have them linked to my master template workbook with special paste links. Problem is that I have to have all 4 books open for the information to update in master book. I need it to just automatically link the information or copy the sheets over to mastertemplate daily. How can this be achieved? The needs to be a simplier way to do this. To had to try my staff. Too many different reports to work with. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to refenence ranges on a closed workbook | Excel Discussion (Misc queries) | |||
linking several worksheets to one workbook | Excel Discussion (Misc queries) | |||
Inserting Filtered RC cell information into other worksheets | Excel Discussion (Misc queries) | |||
New button does not open the template workbook set up | Excel Discussion (Misc queries) | |||
Updating master workbook from source that may/may not exist | Excel Worksheet Functions |