Copy a specific row.

[paesu57]

Hi all

I have a probably simple issue with VBA.

I have 2 Workbooks A and B

I now would like to copy the entire row X from Workbook A to Workbook B.

Row X has to be selected: In Cell "C5" of Workbook B is a Number 12345. There is only one Row in Workbook A which has this number in column A.

So, Select the Row in Workbook A which starts with the equialent Number of C5 in Workbook B and Copy it.

Can anyone assist?

Thank you very much!

Pascal

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[paesu57]

Hello and thank you!
what exactly does this code do?

For i = Range("A" & Rows.count).End(3)(1).Row To 2 Step -1

Thank you!

[JOHN H. DAVIS]

It starts at last row with data in Column A of Workbook A and loops up one cell at a time. In this case when until it reaches a value that has x it exits the loop and the sub.