I have recently taken over a small restaurant and am in desperate need of updation procedures. We currently have all of our paperwork in single files for the date and in a folder for the month. I have about 5 separate reports or files that we use. 3 of them are weekly while the other two are for each day. I have created an excel file that has a copy of all five reports on them. i then created a button that copies the 3 weekly reports to a separate workbook. It also take the first tab copies it into a new workbook and makes a new sheet for each day monday thru sunday and copies sheet 1 to all of them. And the same for the next report. My problem is that I need very little user interaction because my staff is bad with computers and replace my files all the time instead of saving them as new files. If anybody could help me I would appreciate it. What I am looking to do is Open a file every monday morning that asks for the date. It then makes my three new files with the right date and then saves them to the current directory. Trick there is that I would also like it to create a folder for the month, and another for the day, and then save all three files in that folder. That way I have all my reports for that day together in a folder for that day.
PLEEEEESSSEEEE HELP!!!!! My restaurant needs this.
PLEEEEESSSEEEE HELP!!!!! My restaurant needs this.