Creating controls to autofill a form

[Guest]

I use a workbook with several sheets to record and order inventory. The first
cell in every row is our "Order Number", with cells to the right containing
specifics about the item (cost, product code, etc.). I've designed another
sheet to look like an Order Form.

I'd like to select the cell on the inventory sheet containing the order
number, click a control button (or run a macro), and have the related
information for that order number copied & pasted to specific cells in the
Order Form sheet.

How can I do this?

 

[Dave Peterson]

Take a look at Debra Dalgleish's site:
http://www.contextures.com/xlOrderForm01.html
http://www.contextures.com/xlForm03.html
http://www.contextures.com/xlForm02.html

 

[Guest]

Thanks Dave Peterson, for getting back to me so quickly. I'll try these
samples you directed me to and let you know how it works out. I appreciate
the help.