Hello,

I need help! I need a macro which uses 2 sheets. I have a value in Sheet1("F30") which then needs to be found in Sheet2("A:A") i then need it to copy the selection along that row which would be ("B/row number , I/same row number")
I cant use copy entire row. I then need the selected copy to paste back into Sheet1 but the location would be ("G30 , N30")

Forgot to mention, This is done using a button and the value is written in.

If anyone can help that would be great if I am missing any information that you might need I am happy to try supply it

Many thanks
Liam