View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default find a cell and put data in another cell

look in the vba help index for FIND or FINDNEXT if more than one

--
Don Guillett
SalesAid Software

"Mike" wrote in message
...
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