SyedKhurramAli
New Member
- Joined
- Oct 19, 2021
- Messages
- 3
- Office Version
- 365
- Platform
- Windows
Hello! My knowledge to Excel VBA is basic, so please bear with me. Thanking in advance for this.
I am having a data entry form for Home delivery orders, where daily I book order & after delivery it moves from pending worksheet to delivered work sheet & delete the entry from pending worksheet.
Now what I want is that, each day, the Delivered worksheet data should transfer to new workbook, let's say "Delivered Record.xls" & delete the entries in Delivered worksheet. So with each calendar date change the date transfer to "Delivered Records.xls" with next available row, so that previous data remains there.
Please help me out with this!
Thanks
I am having a data entry form for Home delivery orders, where daily I book order & after delivery it moves from pending worksheet to delivered work sheet & delete the entry from pending worksheet.
Now what I want is that, each day, the Delivered worksheet data should transfer to new workbook, let's say "Delivered Record.xls" & delete the entries in Delivered worksheet. So with each calendar date change the date transfer to "Delivered Records.xls" with next available row, so that previous data remains there.
Please help me out with this!
Thanks