using a worksheet range to populate a combo box in excel
Hi Ivan,
I am starting at cell A23 because above that is the rest of a jobsheet.
Address job number work description etc.
I left colum B out for cosmetic reasons but have changed my mind, I
will now use B for the quantity.
I have 2 almost identical worksheets.
1 is called customer copy and all I want on that one is the part
description and quantity. The part description is obtained from
Worksheet Temp parts via the combo box you helped me with earlier.
On the temp parts sheet, the next column is the Part number, then in C
is the trade price. In column D is the list price.
I need this extra information about the part picked by the combo box to
appear in the columns on the sheet called financial copy.
Hope this is clear (only I know whats in my head!!)
Thanks
Kev
|