Copy the Wb_1 - Column A: K, Wb_2 - Column A:E, And to Wb_1_And_2, columns A:O

[marreco]

Hi.
I have two workbook, worksheet both have one each.

I need to copy all cells between columns and rows each for a workbook called 'Wb_1_And_2'

the detail is on the fact that I need to join the two workbook but the workbook called 'Wb_1' has the data to the column 'A' to column 'K'

have another workbook called 'Wb_2' has the data to the column 'A' to column 'E'

here that the detail.

data 'Wb_1' will occupy the columns 'A' to column 'K' of the workbook called 'Wb_1_And_2'

and data 'Wb_2' will occupy the columns 'L' to column 'O' the workbook called 'Wb_1_And_2'

for better comprehension please see the attached

[coreytroy]

Please Login or Register  to view this content.

[marreco]

Hi.
Thanks, but the lines do not have a fixed number, is in accordance with the fulfillment of users.

and I need that data is placed on each line one below the other in the 'Wb_1_And_2'

[marreco]

Hi

Any idea?

Thank you!!!

[xladept]

Hi Marreco,

I moved the Worksheet 2 detail to column A in order to capture it with this:

Please Login or Register  to view this content.

It went to Column P!

[marreco]

Hi.

your skills are amazing!!
was excellent!!
thank you very much!!

[xladept]

You're welcome!