paste union to end of row

[rs1aj]

Running this code will pull the results of B2, D2, F2, G2, H2, I2 and J2 from each ws in my workbook and copy it to the first blank row on "Sheet1". The problem is, I also need N1 and T1 copied and brought over but the "union" command won't allow it since it is on a different row. How can I write the code to also grab N1 and T1 from each ws and bring over to "Sheet1"?

Please Login or Register  to view this content.

[JOHN H. DAVIS]

Does this not work? It should place the second Union right beneath the first.

Please Login or Register  to view this content.

[rs1aj]

It does work but I need them on the same line, not two separate lines.

I need one single row in "Sheet1" to be the result of B2,D2,F2,G2,H2,I2,J2,N1,T1 , in that order on the page.

[JOHN H. DAVIS]

Try:

Please Login or Register  to view this content.

[rs1aj]

Works perfectly. Thanks

[JOHN H. DAVIS]

You're welcome. Glad to help out and thanks for the feedback. Please mark this thread as SOLVED.