Daily Stock Backup

Closed
Herbie - Oct 1, 2009 at 07:56 AM
venkat1926 Posts 1863 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
Related:

1 response

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
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