See attached file. I want "Description of Piece" (col D) and three other columns in the "MainSupplies" workbook to automatically copy into the corresponding columns in the "SpecificPiece#" workbook so I don't have to enter everything twice. This seems like a simple operation, but I've researched it, played with it, can't seem to make it work.
In "MainSupplies" I also want to auto-calculate K/I and insert the answer into column L. That's simple too; but how do I tell Excel to do this calculation over a range (every row in columns K and I)? And then to insert the results into a range (every cell in column L)?
Sorry if this is really basic stuff. I'm new to Excel formulas, have read and experimented without success. Thanks.
Bookmarks