Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.links
|
|||
|
|||
Linking multiple files
-- We have a daily schedule sheet that our power marketers use to enter their daily power sales and purchases. Each schedule is saved in a separate file by using the date as the filename, (i.e. m20060101, m20060102, m20060103€¦ etc). Is there a way to combine all this data into one file so I can eventually link it to an ACCESS database for various reports. There are also situations where there are after-the-fact corrections that are made to a schedule sheet, so would need the data linked somehow so I always have access to the most up-to-date information. I would appreciate any help anyone can give me. Let me know if you need additional info. TIA, Patti Patti |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do i auto create multiple files from 1 with multiple sheets | Excel Worksheet Functions | |||
multiple text files URGENT | Excel Discussion (Misc queries) | |||
importing multiple text files URGENT!!! HELP | Excel Worksheet Functions | |||
importing multiple text files??? | Excel Discussion (Misc queries) | |||
Why do my links break when I burn multiple Excel files to a CD? | Excel Worksheet Functions |