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