View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Shariq Shariq is offline
external usenet poster
 
Posts: 31
Default find IDs in another sheet, copy paste non-adjacent data on orig sh

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!