F
Flintstone
I am tasked with the very tedious assignment of updating about 24 separate
Excel 2007 files every week which require:
- Open File of Current Week
- Update Cell B7 with Week Beginning Date
- Update Cell D7 with Week Ending Date
- Delete Contents of Cells A10:L20 which have been updated throughout the
current week
- Save the updated file with a new Name corresponding to the Next Week
Beginning and Ending Dates
The number of files is growing and I need to find a more expeditious method
of updating this very mundane task. I have attempted to write a Macro, but
have not been successful.
Excel 2007 files every week which require:
- Open File of Current Week
- Update Cell B7 with Week Beginning Date
- Update Cell D7 with Week Ending Date
- Delete Contents of Cells A10:L20 which have been updated throughout the
current week
- Save the updated file with a new Name corresponding to the Next Week
Beginning and Ending Dates
The number of files is growing and I need to find a more expeditious method
of updating this very mundane task. I have attempted to write a Macro, but
have not been successful.