R
Raj
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
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