I am looking for Excel VBA code, to import specific information from "SaleOrders" Sheet to the "Invoice" sheet (please find the excel file here [login to view URL] )
The information to be import, will depend on cell B11 ("Invoice" sheet). Depending on this value, the macro should find all the rows in "saleOrders" sheet that meet the criteria (according to column B) and import the data in sheet "Invoice" in range A16:H24. Please note we are not importing the entire row, only some cells.
Additionally, we need to hide rows in range 16:24, which do not have any content.
The macro should generate one new excel file and one new pdf file for each new different invoice number.
Furthermore the invoice number must evolve in a consecutive way and when the invoice has been saved as pdf and xls, all the data will be send to a specific file containing a registry of all issued invoices.
53 freelancers are bidding on average €339 for this job
Hi there, This looks feasible and I have written many scripts. I am an expert in Excel VBA with over 5+ years of experience. Ping me to discuss more. Thanks Aman
Hi, I can code that faster using sql/ado vba within your Excel xlsm sheet. Regards, Zura Relevant Skills and Experience ms Access/Excel/VB programmer since Ms Office 97 released Proposed Milestones €250 EUR - default