To insert this code into the Workbook_Open event:
1. Copy all of the code shown below. I adjusted it slightly to always reference the sheet named "Sheet1". If your sheet name is different, change any references to Sheet1 to your sheet name.
2. Open the VBA Editor in your workbook (ALT+F11).
3. Double-click the "ThisWorkbook" entry in the left-hand column (the one beneath 'VBAProject (your_workbook_name_here)'.
4. Paste the code below into the right-hand pane.
5. Save and close the workbook.
6. The next time you open the workbook (either manually or via Task Scheduler), the code should run immediately (as long as your macro security is set to low). You may want to put in a test row to make sure it runs.
Hopefully that works for you.
Bookmarks