View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] Racqetsports@gmail.com is offline
external usenet poster
 
Posts: 5
Default 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