copy rows from wb to another

[GRAMMY]

Hi.
I am trying to do a macro that will copy rows from workbook x to workbook y where data in workbook x column a matches my argument in workbook y cell a1. hope this makes sense!
anyway i did this macro but it does not work.

Please Login or Register  to view this content.

[arlu1201]

Are you getting any error?

Also it looks that you have declared x and y as workbooks but you are assigning sheets to them which might be a part of the problem.

[GRAMMY]

I get 'Subscript out of range'

[arlu1201]

Attach the workbook which you are using along with the code. Or a sample workbook so that we can test the code along with the data and help you easily.

[GRAMMY]

Awesome. The code is in 'graftimesag_ugentlig' under module1. The 'timesag_data' is the sheet refered to as x in the code.

Cheers!

[GRAMMY]

I solved this by deleting the rows i dont need after copy. Thanks for your time!