Ask your question Print Format Forum list Help them Statistics Search Charter Forum Office software

Excel: find, copy, paste in good order sheet2

Last answer on Sep 25, 2009 3:20:50 am BST Kris, on Sep 24, 2009 1:03:04 pm BST

Report this message to moderators

Hello,

I have databse in Sheet1, (columnA: name, B: street, C: post code)
in sheet2 I have in column A: the same name like in Sheet1 but not all and in various order, in next columns (B,C,D,E) I've got other value

I am looking for way how to copy value form cell in column A (sheet2), go to sheet1 find right row, copy 3 cell from this sheet (name, street, post code) and paste it in sheet2 in F,G,H

and do the same with other cell in column A until find value specific value (for example STOP)

to be clear:

sheet1
...|.....A.......|.....B........|....C..........|....D......|.......E.....|..F....|...G....|....H...|
1.|..cable.....|.street1....|..code1.....|............|...............|........|.........|..........|
2.|..Egg.......|..street2...|..code2.....|............|...............|........|.........|..........|
3.|..fabric....|..street3...|..code3.....|............|...............|........|.........|..........|

sheet2
...|.....A.......|.....B.......|....C...........|....D......|.......E......|..F....|...G....|....H...|
1.|.fabric.....|....BFI�.|...house.....|..kito.....|...22.00...|........|.........|..........|
2.|.cable.....|....lost.....|�dance.....|..craig...|...21.00....|........|.........|..........|
3.|.Egg.......|....roller...|minimal�|..dale....|...22.00�.|........|.........|..........|
4.|.STOP....|

take value form 1A (sheet2): fabric
find it in sheet1 and copy ABC (|.fabric.....|.street3...|..code3.....|)
in to sheet2
after all should it look like this

sheet2
...|.....A.......|.....B........|....C............|....D........|.......E.......|....F.........|......G..........|......H.........|.
1.|.fabric.....|....BFI.....|..house.......|..kito.......|...22.00�.|.fabric.....|...street3.....|...code3.....|
2.|.cable.....|....lost......|..dance.......|..craig�..|...21.00�.|..cable.....|...street1....|....code1.....|
3.|.Egg.......|....roller...|..minimal�|..dale�...|...22.00�|....Egg.....|...street2.....|...code2.....|
4.|.STOP....|

Thanks!
Kris

Configuration: Windows XP
Firefox 3.5

Best answers for « Excel: find, copy, paste in good order sheet2 » in :

Excel � Macro for copy & paste selected range Show Excel � Macro for copy & paste selected range Issue Solution Note Issue I have a summary of data by month in one sheet and the raw data in another sheet. Instead of creating multiple worksheets for my raw data for each month, I want...

Copy/Paste problems when using Firefox Show Copy/Paste problems when using Firefox Pushow Adware Extensions It happens that sometimes, Firefox refuse to copy/paste items. Two assumptions can be made: Pushow Adware You have been infected by an adware, named pushow**.dll...

Excel macro for copy & paste selected range (Solved) Show

Vi/Vim - Avoid tabs when making a copy/paste Show[VI/VIM] Avoid tabs when making a copy/paste By default, when you make a copy and paste in vi or vim (through an remote SSH session), it adds incremented tabs at each line. To solve this problem,simply type: set paste in the window or add the...

Quick Copy/Paste under Ubuntu ShowQuick Copy/Paste under Ubuntu Intro Uses: Intro Under Ubuntu there is a quicker alternative to make a Copy/Paste other than using the native CTRL V and CTRL C combinations . You simply select the target text (it is uploaded in...

Copy, Paste and Cut not functioning ShowCopy, Paste and Cut not functioning Issue Solution Issue I am having a problem, every time i want to copy, paste and cut my files, it's not working. Even am trying to use the keyboard combinations, CTRL+X, CTRL+C, and CTRL+V but it's...

Cant Copy,Paste and Cut not working Show

Copy Paste Option is not working Show

Copy/paste a shortcut file to desktop Show

Download CopyTrans Suite ShowCopyTrans Suite is a set of practical tools for your Ipod or Iphone. It contains: · CopyTrans v2.37 · CopyTrans Photo v2.21 · iLibs v1.13 · iCloner v1.07 · CopyTrans Doctor v1.015 · CopyTrans Manager v0.720 · SyncGuardian...

Linux - The Vi editor ShowIntroduction to Vi Despite its very limited ergonomics, Vi i is one of the most popular text editors texte under Unix type systems (with Emacs and pico). Under Linux, there is a free version of Vi called Vim (Vi Improved). Vi (pronounced vee-eye)...

Ask your question Reply

venkat1926, on Sep 25, 2009 3:20:50 am BST

Suppose headings are in row no.1 both in sheets1 and 2.

in sheet 2 and in cell F2 copy paste this formula

=VLOOKUP($A2,Sheet1!$A$1:$C$100,COLUMN(A$1),0)
copy F2 both down and across to column H

I do not know why you want the names in column F when this is already available in column A

I suppose the total number of rows is <100 if more change "C100" in the formula suitably

read about vlookup function in excel help . it is extremely useful function

Reply to venkat1926

Ask your question Reply