1500 Excel Invoices Grouping into One Master Excel Sheet
Budget: $750 – $1,500 USD
Hello
We have around 1500 invoices made on Excel in the same format but each containing different data of the customer we sold to and the product we sold. We want to group them into one master excel sheet.
I want to know if it is possible to have certain macros or formula that will extract the data from the 1500 invoices (each invoice is in a different excel tab) and take all the lines one by one into one excel sheet
We have around 1500 invoices made on Excel in the same format but each containing different data of the customer we sold to and the product we sold. We want to group them into one master excel sheet.
I want to know if it is possible to have certain macros or formula that will extract the data from the 1500 invoices (each invoice is in a different excel tab) and take all the lines one by one into one excel sheet