Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pop-up box
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? |