Hi All

I am a novice when it comes to VBA in excel and I have the below problem I am trying to solve.

I am trying to get a Macro to copy the data from sheet B to sheet A that matches the value of a cell in Sheet A.
I did try a lookup function but it just returns the same info over and over.

Any help would be appreciated.

Thanks

Tony