Hi,

We are updating the excel spreadsheet that we enter all the sales details in
at the end of the day. We currently have the system where we open the
worksheet template we've made and save as for that week ending and enter
monday's date in a cell on one tab titled monday. All other day's tabs until
sunday then simply fill themselves in (Obviously just a +1 format to the
previous day's tab. i was wondering if i can use Macros or something so that
when we open the template. a box pops up asking for the week ending date
(i.e. 13/12/09) which then fills in all the dates for that week to their
respective tabs?

And also can i set it so it only pops up that one time when we open the new
template to start that new week?