Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to find and copy cells between sheets??
suppose i hav two sheets as follows...
SHEET 1 ID location country 1 211 2 315 3 234 4 146 5 254 6 147 7 631 8 942 9 845 10 413 and sheet 2 as id name customer location region 1 211 steve ford onsite usa 2 315 alex nissan offshore india 3 631 white gm onsite usa 4 146 rishi tata onshore india 5 254 john ford offshore india 6 147 bill ford offshore india 7 295 george nissan onshore usa 8 942 enayan gm onshore usa 9 845 mike tata offshore usa 10 413 ali gm onsite india 11 456 murray gm onsite usa 12 486 tim tata offshore india 13 546 david tata onsite inida 14 896 micheal nissan onsite usa 15 234 alison nissan onsite france now i have to search sheet2 and fill up sheet 1 with the corresponding entries....both the sheets are in the same workbook... if someone can help me it would be great... |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to find and copy cells between sheets??
Hi Rishi,
See responses at your earlier thread. --- Regards, Norman "rishi" wrote in message oups.com... suppose i hav two sheets as follows... SHEET 1 ID location country 1 211 2 315 3 234 4 146 5 254 6 147 7 631 8 942 9 845 10 413 and sheet 2 as id name customer location region 1 211 steve ford onsite usa 2 315 alex nissan offshore india 3 631 white gm onsite usa 4 146 rishi tata onshore india 5 254 john ford offshore india 6 147 bill ford offshore india 7 295 george nissan onshore usa 8 942 enayan gm onshore usa 9 845 mike tata offshore usa 10 413 ali gm onsite india 11 456 murray gm onsite usa 12 486 tim tata offshore india 13 546 david tata onsite inida 14 896 micheal nissan onsite usa 15 234 alison nissan onsite france now i have to search sheet2 and fill up sheet 1 with the corresponding entries....both the sheets are in the same workbook... if someone can help me it would be great... |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to find and copy cells between sheets??
in B1 next to 211 put in
=vlookup($A1,Sheet2!$A:$E,column()-1,False) then drag fill to the right for a total of 4 cells. Select B1:E1 and drag fill down. Optionally to remove the formulas and leave the data, select that section and do Edit=Copy, then do Edit=Paste special and select values. -- Regards, Tom Ogilvy "rishi" wrote: suppose i hav two sheets as follows... SHEET 1 ID location country 1 211 2 315 3 234 4 146 5 254 6 147 7 631 8 942 9 845 10 413 and sheet 2 as id name customer location region 1 211 steve ford onsite usa 2 315 alex nissan offshore india 3 631 white gm onsite usa 4 146 rishi tata onshore india 5 254 john ford offshore india 6 147 bill ford offshore india 7 295 george nissan onshore usa 8 942 enayan gm onshore usa 9 845 mike tata offshore usa 10 413 ali gm onsite india 11 456 murray gm onsite usa 12 486 tim tata offshore india 13 546 david tata onsite inida 14 896 micheal nissan onsite usa 15 234 alison nissan onsite france now i have to search sheet2 and fill up sheet 1 with the corresponding entries....both the sheets are in the same workbook... if someone can help me it would be great... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy cells to specific sheets | Excel Worksheet Functions | |||
Macro - 2 Sheets - Find/Insert/Copy/Paste | Excel Programming | |||
Find values from cells in multiple sheets | Excel Worksheet Functions | |||
copy & paste to all Sheets to the same cells | Excel Programming | |||
using Cells.Find between 2 sheets | Excel Programming |