Hi,
I have a created an invoice, and a stocklist, on separate worksheets in a
workbook using EXCEL 2003. On the stocklist worksheet, I have lot number
1-500 in Column A, and a description for each in Column B, and I want to
enter a number in Columb A on the invoice worksheet and have the
corresponding description come up in Column B on the invoice......So that if
someone buys lot number 100, I can enter "100" into Column A in the invoice
worksheet and have that description show up in Column B.
Your advice will be very much appreciated.
--
Thank you,
Sarah