Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto Entering Dates Across Seven Worksheets and Navigating
Hello there,
In a workbook with 7 sheets (named Period 1, Period 2, ..., Period 7), I would like to attach code to a macro that does the following: 1.) Go to the sheet named Period 1, 2.) Find the last used cell in row 12, 3.) Insert today's date into the next cell to the right (formatted mm/ dd/yy). 4.) Do this to all of the sheets whose name starts with "Period." 5.) Lastly, put the cursor 3 cells below the newly entered date on the sheet named Period 1. Thank you very much for any and all help on this code. Tracy |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
navigating between worksheets | Excel Discussion (Misc queries) | |||
Navigating among worksheets | Excel Programming | |||
Navigating between worksheets. | Excel Worksheet Functions | |||
Entering Dates and auto-completing | Excel Programming | |||
Navigating between worksheets | Excel Programming |