Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup - copy.paste values macro? | Excel Programming | |||
Automating copy/paste/paste special when row references change | Excel Programming | |||
lookup and copy data and move it upwards and paste | Excel Programming | |||
Copy and Paste macro needs to paste to a changing cell reference | Excel Programming | |||
lookup,copy, paste macro?? | Excel Programming |