Combining many invoices

[Dardus]

I have a challenge that I have been reviewing and cannot seem to get the right code down. I have many excel invoices that need to be combined into one excel invoice. The challenge is with 12 invoices to combine, it takes time to copy and paste all that data from one invoice to a master invoice. Could someone assist in the code to consolidate the data on the invoices?
The first worksheet houses a summery of charges. All the invoice numbers need to be posted under the summery. i.e.
Invoice 111111
Invoice 222222
Invoice 333333

Sheet 2 through 5 houses a breakdown of charges starting at cell A10. I would like to have the data on invoice 222222, sheet 2 from A10 to the bottom of the data copied and pasted to the bottom of Invoice 111111, sheet 2. Same with the remaining sheets.
I have attached a sample invoice for review without data.

Thank you for the help in advance.
Drive Link to Excel Invoice Sample

 

[My Aswer Is This]

I may be able to help.
Let's start by defining terms.

Excel has:
Workbooks
Worksheets
Rows which are sometimes referred to as Records
Columns which are sometimes referred to as Fields

So you used the term Invoice.

So is a invoice and a record the same as a row.
Or is a invoice a sheet?

And if each invoice has a number assigned to it which column on the sheet has then invoice number?
Please say something like column (1) or Column(5). Do not say Invoice column

That's why when you say:

I would like to have the data on invoice 222222, sheet 2 from A10 to the bottom of the data copied and pasted to the bottom of Invoice 111111

I'm not sure where we will fine 222222

So if you could clear this up for me I may be able to help.​

 

[Dardus]

I may be able to help.
Let's start by defining terms.

Excel has:
Workbooks
Worksheets
Rows which are sometimes referred to as Records
Columns which are sometimes referred to as Fields

So you used the term Invoice.

So is a invoice and a record the same as a row.
Or is a invoice a sheet?

And if each invoice has a number assigned to it which column on the sheet has then invoice number?
Please say something like column (1) or Column(5). Do not say Invoice column

That's why when you say:

I would like to have the data on invoice 222222, sheet 2 from A10 to the bottom of the data copied and pasted to the bottom of Invoice 111111

I'm not sure where we will fine 222222

So if you could clear this up for me I may be able to help.​

Sure. 222222 is just the invoice number. I was attempting to put the files into one folder and have a loop grab the information from A10 to O10 and how many ever rows on that invoice and combine it with invoice 11111.
The invoice numbers are unique and are just a set of numbers that add up like a check in a check book.

Does that help?

 

[My Aswer Is This]

No that does not really help me.
But maybe I'm slow at understanding.

Maybe someone else here will be able to help you.

This is beyond my knowledgebase.
I will continue to monitor this thread to see what I can learn.

 

[Dardus]

Maybe it is my explication. You have 5 individual bills. These bills are labeled 111, 222, 333, 444, and 555. These numbers are just the names of the bill.
I am attempting to take the charges in each of the 5 invoices and combine them into one invoice.
In the first bill, invoice 111
Tab 1 (or the first sheet) is a summary of the charges.
Tab 2 shows the supplies
Tab 3 shows an estimate of the job
Tab 4 is extra charges
Tab 5 is estimated charges

The other invoices are setup the same way.
I need the charges on the second bill (222) from tab 2, 3, 4 and 5 to be placed at the bottom of the charges on the first bill (111) in the respective tabs.
Then the third bill (333) charges from tab 2, 3, 4 and 5 placed at the bottom of the charges on the fist bill (111) which include the charges from bill 222.
Then the forth bill (444) charges from tab 2, 3, 4 and 5 placed at the bottom of the charges on the fist bill (111) which include the charges from bill 222 and 333.
and so on for all 5 bills.
Bill 111 will then have all the charges from all five invoices.