I have a workbook that is used once a day to enter production numbers. It's filled in, saved and printed, and emailed. The next days it's overwriten and used again. Would there be an easy way to have these numbers moved each day to a new sheet and saved? There is data from B7 to B103 that is used. It would be nice to keep it by date, or seperate by crew, (a-b-c-d). How would you trigger this? If it's saved by the SAVE action, what if someone saves it several times? Thanks for any advice.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Can This Be Done? Thanks
- Thread starter rockyw
- Start date
MrKowz
Well-known Member
- Joined
- Jun 30, 2008
- Messages
- 6,653
- Office Version
- 365
- 2016
- Platform
- Windows
Rockyw,
There are several ways we can go about this. Depending how your data is laid out, it might be easy to save it to separate tabs, or just create a single consolidated tab. Also, triggering the event can be done by button (manual), by save (automatic), or various other ways.
Would you be able to post some sample data?
There are several ways we can go about this. Depending how your data is laid out, it might be easy to save it to separate tabs, or just create a single consolidated tab. Also, triggering the event can be done by button (manual), by save (automatic), or various other ways.
Would you be able to post some sample data?
Upvote
0
Similar threads
- Solved
- Solved
