Macro to create sales report

[Closed]
Report
Posts
1
Registration date
Friday November 9, 2012
Status
Member
Last seen
November 9, 2012
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
upload sample workbook at some public file sharing site and post back the link to the file back here to help understanding your issue