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