Macro to create sales report

Closed
sreejeshsanthosh Posts 1 Registration date Friday November 9, 2012 Status Member Last seen November 9, 2012 - Nov 9, 2012 at 06:22 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Dec 1, 2012 at 08:19 AM
Hello,

i have a set of invoice] in excel formats in a folder. I need to generate a sales report for this. sales report should contain bill no, date, customer details, customer address, tax amount and bill total amount. in all invoices this comes in same cells. in the report all bill no should come in same row one after another. can any one help me pls
pls suggest me a macro for this in excel

1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Dec 1, 2012 at 08:19 AM
upload sample workbook at some public file sharing site and post back the link to the file back here to help understanding your issue
0