Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatically updating a workbook from a different workbook day by
I am using Excel 2003 and I am wondering if there is a way to automatically
update an Excel workbook from another workbook. I have example files, and some comments within that explain this better, however I can not figure out how to insert the example files into this posting. In a nutshell I have one workbook that gets updated every day and has the same name day after day. I want the data from that work book to automatically populate another work book every day (titled "to be populated") based on the date on the populated work book titled "updated data". If what I want to do can not be done, are the other suggestions or methods to achieve this? "updated data" work book A1 = Date A2 =today() B1 = A B2 = 3 C1 = B C2 = 4 "to be updated" work book A1 = Date A2 = 9/17/06 A3 = 9/18/06 A4=9/19/06 B1 = A B2 = 5 B3 = Populated from updated data book cell b2 B4=Poulated the next day from b2 C1 = B C2 = 2 C3 = Poluated from updated data book cell C2 C4 = Populated the next day from cell C2 Thanks for any insight!!! :) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Set macro to run automatically when closing workbook? | Excel Discussion (Misc queries) | |||
saving workbook to destination file automatically | Excel Worksheet Functions | |||
Automatically updating Graphs | Excel Worksheet Functions | |||
Updating master workbook from source that may/may not exist | Excel Worksheet Functions | |||
Updating sheets within a workbook | Excel Discussion (Misc queries) |