Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
find a cell and put data in another cell
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
find a cell and put data in another cell
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
find a cell and put data in another cell
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
find a cell and put data in another cell
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 -- 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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
find a cell and put data in another cell
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 -- 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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
find a cell and put data in another cell
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 |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
find a cell and put data in another cell
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 |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
find a cell and put data in another cell
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|