Make dropdown item list in invoice sheet

  • Thread starter Thread starter tim
  • Start date Start date
T

tim

Hi all
I have made an invoice in sheet1 and have list of items in sheet2.
How can I make a dropdown list in invoice showing sheet2 items and at the
same time get the unit price for the item too?

i.e.


In Sheet1(Invoice) : B20 = Items Descritpion C20 = Unit Price

in Sheet2(Stock List) : A2 = Items description C2 = Unit Price


regards
 
Back
Top