| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
find IDs in another sheet, copy paste non-adjacent data on orig sh
Using Excel 2007.
Sorry, forgot to specify. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
find IDs in another sheet, copy paste non-adjacent data on orig sh
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 "Shariq" wrote in message ... 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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| When data match, copy adjacent value to adjacent column | Excel Worksheet Functions | |||
| how do i find an email and copy the text and paste into excel sheet | Excel Programming | |||
| Macro to open workbook and copy and paste values in to orig workbo | Excel Worksheet Functions | |||
| code to FIND value, copy, paste values onto other sheet | Excel Programming | |||
| Search, find, copy muliple cells from new sheet and paste | Excel Programming | |||
Linear Mode
