Macro to look for cell value present in sheet 1 in sheet 2

[mgnab]

Hello everyone.

I'm stuck with this part of a macro I'm creating and really appreciate some help.

I would need it to do the following:

- Find if the value in the first visible cell after cell A1 in sheet 1 is present anywhere on sheet 2 (it can happen to have a filter and the cell after A1 being A9 i/o A2)

- in the value is present on sheet 2, copy the active cells on the same row (for example, if the value is in cell A7, copy everything from A7 to M7)

- after copying, I need it to paste the copied values on the original cell on sheet 1 (in this case paste in the first visible cell after cell A1)

- after all this, I need it to loop until it gets to the first empty cell in Sheet 1, thus ending the macro.



Hope you guys can help me just with these guidelines, as i'm having some trouble trying to attach a file.




Thank you all in advance.

[nigelog]

Please Login or Register  to view this content.

but I dont understand your last sentence

[mgnab]

Nigelog thank you for the code. I'll give it a try and let you know the result.

As for my last sentence, sorry for the confusion, I meant attach an excel file on the post as an example of the data where i need to run the macro.

[nigelog]

No this "- after all this, I need it to loop until it gets to the first empty cell in Sheet 1, thus ending the macro."

[mgnab]

Ah ok!

I need it to then after checking one cell/ value, it checks the next one and performs the same actions.

[nigelog]

If the data if filtered the next value will be the same if present