find a cell and put data in another cell

M

Mike

Hi i have a sheet with 600 numbers in column A, what i want to do is to be
able to search for a number in column A from a different sheet and place a
name by that number in column B. Hope you can help
 
B

bj

Look at Vlookup in help.
do you want the name put in column B in the first or second sheet?
 
M

Mike

Hi thanks, i want the name to be put into the column next to the number in
sheet 1, and i want it to remain there even when its removed from sheet 2
 
M

Mike

i want the name to be put in the column next to the number i searched for in
sheet 1, i want it to remain in sheet 1, even when i remove it from sheet 2
 
M

Mike

i want the name to be put in the column next to the number i searched for in
sheet 1, i want it to remain in sheet 1, even when i remove it from sheet 2
 
B

bj

to make the name stay on sheet 1 even after it is removed from Sheet 2, you
will need to use a macro
 
M

Mike

thanks bj, can i search and place the data in from a macro, and do you have
one in mind please
 
Top