Daily Stock Backup

Closed
Herbie - Oct 1, 2009 at 07:56 AM
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Oct 1, 2009 at 09:36 PM
Hello,
I am trying to create a daily stock book from the consolidated monthly stock book 'stock-dept.xls'. The daily stock workbook name should correspond to the date 'ddmmyyyy'.xls

Alternately, the daily stock should be updated in the workbook 'monthlystock.xls' with worksheets named as per the date 'ddmmyyyy'.

Please advise

1 reply

venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 810
Oct 1, 2009 at 09:36 PM
do you want it different workbooks or different worksheets?
in which column and in which sheet of stock.xls the date appers.?
0