Forum Discussion

Joe Vibbard's avatar
Joe Vibbard
Copper Contributor
Nov 20, 2017

Form use to adjust multiple sheets?

Ok so, my goal with this is to find out how to enter some basic information into a few cells in an inventory management workbook and use either a button or form to read the information from those cells and place a new entry to the respective receiving or shipping sheets as well as adjust inventory quantities on a different sheet. Currently I have VLOOKUP formulas in place to generate the additional information for the parts that's required for the entries on the receiving and shipping sheets. Example below. The cells following the "Info:" cell contain the VLOOKUP formulas. I'd like to fill in the top 3 fields, have the vlookups generate the rest below, and click a button to add the entries to the receiving sheet in their appropriate fields on a new line each time. What's the easiest way to do this in excel if it's even possible?
Part # Plant # Quantity
Incoming Inventory: 180079 1001 1
Info: BOLT-5/16-18 HEX McCook
No RepliesBe the first to reply

Resources