Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatically updating cells when opening workbook
I am working on a primary worksheet "Dashboard" where information in column B
associated to today's date in a secondary worksheets "Scheduled" is copied to cells (Q27) in 'Dashboard' upon opening the workbook if the cell in column B associated to today's date in worksheet "Draw" is empty. Both 'Scheduled' & 'Draw' worksheets have dates starting with 05/01/09 down in column A and the pertinent data in Column B. Hope this makes since. Can anyone help write the code that would make this happen? My ultimate goal is to not only copy data associated to today in Q27 but to also copy to Q28 with =Date +1, Q29 with =Date +2 and so forth through = Date + 7. That should allow me to look out 7 days into the future on my primary worksheet. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Personal workbook not opening automatically | Excel Discussion (Misc queries) | |||
How to stop spreadsheets automatically updating on opening? | Excel Discussion (Misc queries) | |||
Automatically updating a workbook from a different workbook day by | Excel Discussion (Misc queries) | |||
Updating LINKS when opening a workbook | Excel Worksheet Functions | |||
automatically opening workbook | Excel Discussion (Misc queries) |