Lookup and copy paste
 

Hi,


Column A of Sheet 2 has a list of category names and columns B to E of
each row have values associated with the category name in Column A.
The cells in Columns B to E also have comments.

The requirement is this:

Column A in Sheet1 is for also for category names (same as those in
Column A of Sheet 2). I am looking for code that will look up a value
in Column A of Sheet1 in Column A of Sheet 2 and then copy cells in
Columns B to E of the matching row in Sheet 2 and paste them in
Columns B to E of the row in Sheet 1. (Something similar to a vlookup,
except that cells have to be copied and pasted instead of values being
looked up).

Thanks in advance for the help.

Regards,
Raj