Did you see my suggestion?

--
Don Guillett
SalesAid Software

"Mike" wrote in message
...
thanks bj, can i search and place the data in from a macro, and do you
have
one in mind please
--
thanks


"bj" wrote:

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



"Mike" wrote:

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
--
thanks


"bj" wrote:

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

"Mike" wrote:

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
--
thanks