Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Temp File
Happy Holidays! Does anyone have any suggestions on how
to take select information from multiple reports (in Excel) and put that information into a temporary file (Excel)and hold it until I am ready to use it for a mass report? I want the information update everytime I run one of the reports. The reason that I am needing this is because I have five different reports that I run on a monthly basis. I want to take select information from each of those reports and put it into one big report. I want the temporary file to update when I run one of those five reports. Each report needs to be on a separate sheet. I need the sheet to update when I run the small report. When this update is done, I don't want to override the file, I want to override the sheet. Then, I want to create a macro to retreive the information from the temporary file. Are there any suggestions on how to get this started? Any help would be greatly appreciated. Thanks in advance! Julie |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel File saved as Temp file | New Users to Excel | |||
Finding of temp file | Excel Discussion (Misc queries) | |||
Problem using obj.Namespace(sourceFileName) Namespace(DestinationFilename).Itemsand then opening the xls file which creates a Temp Folder inside Temp | Excel Discussion (Misc queries) | |||
Finding a temp file | Excel Discussion (Misc queries) | |||
Location of Temp File(s) - If any | Excel Discussion (Misc queries) |