I have written a spreadsheet for a mates small business.
He saves a seperate workbook for each customer.
What i want to be able to do is use a batch file or macro ?
I don't know which would be the best way to go- to open each customers sheet in turn, read the contents of 5 different cells
representing GST, Total, Customer name, date, invoice No. and transpose them to a seperate sheet for the purpose of keeping the tax department records.
All workbooks are saved in My Documents to save confusion for my customer
All filenames contain an element in the filename which is (-UT) for example
customer-UT0001.xls which could be used in a wildcard search to search through
the filenames in the My Documents folder.
My other problem is that i need to be sure details added from each sheet will not be duplicated when macro or batch file is subsequently run over again.
Cell references are Date A3 , Customer name B12 , GST F28, Total I28, Invoice no I3.
I hope there is enough information here for someone to be able to help me.
I would like to be able to run the macro/batch every 3, 6, or 12 months,
transpose all the necessary information onto a new sheet. No cell references
etc have been defined for the new sheet as of yet but the name for the sheet
will be UT-gst.xls References running straight down the page A1:A1000 would be quite OK.
All help will be appreciated
Regards to all members Coco.
He saves a seperate workbook for each customer.
What i want to be able to do is use a batch file or macro ?
I don't know which would be the best way to go- to open each customers sheet in turn, read the contents of 5 different cells
representing GST, Total, Customer name, date, invoice No. and transpose them to a seperate sheet for the purpose of keeping the tax department records.
All workbooks are saved in My Documents to save confusion for my customer
All filenames contain an element in the filename which is (-UT) for example
customer-UT0001.xls which could be used in a wildcard search to search through
the filenames in the My Documents folder.
My other problem is that i need to be sure details added from each sheet will not be duplicated when macro or batch file is subsequently run over again.
Cell references are Date A3 , Customer name B12 , GST F28, Total I28, Invoice no I3.
I hope there is enough information here for someone to be able to help me.
I would like to be able to run the macro/batch every 3, 6, or 12 months,
transpose all the necessary information onto a new sheet. No cell references
etc have been defined for the new sheet as of yet but the name for the sheet
will be UT-gst.xls References running straight down the page A1:A1000 would be quite OK.
All help will be appreciated
Regards to all members Coco.