Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
macro help
please help
iwant to make a macro that consists of- in Cell a1 my stock number 1541 in cell b1 my part name crisps when i enter my stock number i want my part name to appear. is this possible?? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
macro help
Hi Mantha,
Look at vLookup in Excel help. Even better, see debra Dalgleish's tutorial at: http://www.contextures.com/xlFunctions02.html --- Regards, Norman "mantha09" wrote in message ... please help iwant to make a macro that consists of- in Cell a1 my stock number 1541 in cell b1 my part name crisps when i enter my stock number i want my part name to appear. is this possible?? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
macro help
Hi
On Sheet2, set up a table of Stock numbers and Names starting in A2 A B Stock No. Name 1541 Crisps 1843 Coca Cola etc. Then on Sheet1 in cell B1 =VLOOKUP(A1,Sheet2!$A$2:$B$100,2,0) Change the value of 100 in the above formula to include the last row of data you have entered in your table on Sheet2. Regards Roger Govier mantha09 wrote: please help iwant to make a macro that consists of- in Cell a1 my stock number 1541 in cell b1 my part name crisps when i enter my stock number i want my part name to appear. is this possible?? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
macro help
thank you, ill give it a go
"Norman Jones" wrote: Hi Mantha, Look at vLookup in Excel help. Even better, see debra Dalgleish's tutorial at: http://www.contextures.com/xlFunctions02.html --- Regards, Norman "mantha09" wrote in message ... please help iwant to make a macro that consists of- in Cell a1 my stock number 1541 in cell b1 my part name crisps when i enter my stock number i want my part name to appear. is this possible?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Editing a simple macro | Excel Worksheet Functions | |||
Can T Get Macro To Run! | New Users to Excel | |||
Closing File Error | Excel Discussion (Misc queries) | |||
Help with macro looping and color query function | Excel Discussion (Misc queries) | |||
Date macro | Excel Discussion (Misc queries) |