find IDs in another sheet, copy paste non-adjacent data on orig sh

S

Shariq

I have a list of IDs in Col AI on Sheet 1.

I'd like to find the ID on Sheet 2, copy data from the corresponding row,
then paste that information adjacent to the ID on Sheet 1.

For example:
*Cell AI1 contains the ID "9".
*I'd like to find the ID "9" on Sheet 2 (contained in Col M), copy the data
on the corresponding row (contained in Cols V, AJ, AP, AO, and AT).
*Paste data into Col AM:AQ

I hope that made sense. Any assistance anyone can provide is much
appreciated! Thanks!
 
B

Bernard Liengme

Do your really want to COPY or would a LINK that displays the data by use of
a formula do?
If yes, look under VLOOKUP in Help and come back if more details are needed
best wishes
Bernard Liengme
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Search the list of Ids in the records 1
A For Each in Range... with a .Find(what:="TJ", ... in it problem 15
Copy Application.Union(c.Offset(0, 1), c.Offset(0, 2)... to a list onsame & another sheet 27
Eliminate blanks while copy row and transpose 11
Create if partial match then copy and paste data from one cell to another 1
Sub to stack data n paste unique order ID lines 3
Sub to carve out uniques based on col header whose position may va 6
Find values of a column in another and paste range of rows 1

Top