Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Match , copy paste (using find?)
Hi,
Basically what I have is two excel sheets. One extensive list of accounts and one with a selection of accounts from the extensive list. Sheet 1 has a selected list of account numbers in Col A (about 400). And nothing in col B sheet 2 has a total list of account numbers in Col A (about 3000). And data in col B. I need to find the accounts on sheet 1 in sheet 2, and copy the data in the B col of sheet 2 into the b col of sheet 1 for the relative account number. I'm looking at Selecting A1(a/c number) finding the account number in sheet 2, copy B2 from sheet 2, and pasting back in sheet one in B1, then move onto A2, until the list is complete. Can anyone help with this? Thanks Carl |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Match , copy paste (using find?)
Don't use VBA, use VLOOKUP()
In Sheet1, B1 enter: =VLOOKUP(A1,Sheet2!A$1:B$3000,2) and copy down -- Gary''s Student - gsnu200772 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Match , copy paste (using find?)
Gary,
Thank you very much, So simple yet works a treat.. One for my notebook!! Cheers Carl "Gary''s Student" wrote: Don't use VBA, use VLOOKUP() In Sheet1, B1 enter: =VLOOKUP(A1,Sheet2!A$1:B$3000,2) and copy down -- Gary''s Student - gsnu200772 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Match , copy paste (using find?)
Is there anyway to amend this so it tells you it's not found what it's
looking for rather then copying the last posted dated? "Gary''s Student" wrote: Don't use VBA, use VLOOKUP() In Sheet1, B1 enter: =VLOOKUP(A1,Sheet2!A$1:B$3000,2) and copy down -- Gary''s Student - gsnu200772 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Compare col and match then copy and paste | Excel Discussion (Misc queries) | |||
Copy Cell, Paste based on a match. | Excel Programming | |||
Find/Copy/paste.. then Find/Paste - not working ... at all.... | Excel Programming | |||
help with match, copy, paste please | Excel Programming | |||
Find text in another workbook and paste if found match - VBA | Excel Discussion (Misc queries) |