N
nd2006
Hi
I have a small problem, one that is probably fairly simple to solve bu
i hardly ever use excel in depth! I am trying to create a little workbo
to facilitate an ordering procedure, it has a stock database on on
sheet, and i want to be able to type an id no. into the first sheet
and that to retrieve all data for that id in the second sheet. IE so i
i put in a value of 25, the product with the id of 25 will appear in th
cells next to it, showing stock description, price etc. This is the
repeated down to create an order sheet. I have worked out how thi
works using an index and match formula, but my problem is that i need
user friendly way of inputting the ID in the first place.
Ideally there would be an add button which brought up a parameter inpu
field, which you type the number into, and then that creates a new row
puts in the formula and adjusts the code of it to suit the parameter
but not only have i forgotten how to do this, the final sheet needs t
go on a pda with pocket excel, so i cant use any VB etc as it wont wor
with pocket excel.
Anybody have any suggestions?
Thanks in advance for any help!
Nic
I have a small problem, one that is probably fairly simple to solve bu
i hardly ever use excel in depth! I am trying to create a little workbo
to facilitate an ordering procedure, it has a stock database on on
sheet, and i want to be able to type an id no. into the first sheet
and that to retrieve all data for that id in the second sheet. IE so i
i put in a value of 25, the product with the id of 25 will appear in th
cells next to it, showing stock description, price etc. This is the
repeated down to create an order sheet. I have worked out how thi
works using an index and match formula, but my problem is that i need
user friendly way of inputting the ID in the first place.
Ideally there would be an add button which brought up a parameter inpu
field, which you type the number into, and then that creates a new row
puts in the formula and adjusts the code of it to suit the parameter
but not only have i forgotten how to do this, the final sheet needs t
go on a pda with pocket excel, so i cant use any VB etc as it wont wor
with pocket excel.
Anybody have any suggestions?
Thanks in advance for any help!
Nic