Thread: Really new: Copy additions/updates to cell contents into second workbook

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.

Originally Posted by arlu1201

I have the same question as Roy...what is the purpose of duplicating the data in 2 sheets?

Regarding your formula, you can put this in L2 and drag it down to how many ever rows you need. Use this formula -

=K2/I2

Thanks folks. I played with it and came up with =IF(K14<>0,K14/I14,"") which seems to have the desired effect. Excel: Not Like SQL. I am not the only one who will be using these sheets; I don't need the two sheets, but the other person is even less an Excel expert than I am and I'm trying to make it really easy to do what needs to be done.