Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Linking One worksheet to Two different workbooks with Daily Dates.
I have to control values on 100 accounts EVERY DAY.
This information goes to TWO different reports, and it is not fun to type same thing THREE TIMES. 1. One workbook has EACH DAY OF THE MONTH with all accounts in each (all customers together in one page). Worksheet Sep1 Sep2 Sep3 Sep4 (all customers in each worksheet) 2. One workbook has EACH CUSTOMER with each day of the month in it. Client1 Client2 Client3 Client 4 (all days of the month in each worksheet) So... how do I input information only ONCE and update into both different workbooks and WITHOUT "previous days/info" being updated into "today's" information? If I use ONE MASTER INPUT worksheet (so I type the same info only once and NOT 3 times!!!), it will "delete" Sep1 and/or Client1 and update with the last day I input. Other way, how do I keep past days (links) without updating with today's input? I want Sep1 and Client1 information to be there when I get to Sep30 and not have all my previous days "deleted" (updated) into Sep30. I am pretty sure I was not clear, but I gave a try. Thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Worksheet Linking problem | Excel Discussion (Misc queries) | |||
Linking information between workbooks | Excel Worksheet Functions | |||
Linking workbooks in 2003 | Excel Worksheet Functions | |||
Linking several workbooks | Excel Discussion (Misc queries) | |||
Automatic updating worksheet data between different workbooks | Excel Worksheet Functions |