can an array update only once?

[Guest]

I have an array formula that matches product codes on the active worksheet to
corresponding product costs in another workbook. For inventory purposes, I
want the formula to return the total value of the product at the time I make
the entries. That is working fine. My question is, how can I then freeze
those values, so that if the product cost changes in the future, it won't
affect my past inventory amounts?

Thanks!

 

[Guest]

Either freeze the inputs or place the formulae with values.

 

[Guest]

Yes, that's what I would like to do, but how please?

Thanks

 

[Gord Dibben]

Copy the range, then in place Edit>Paste Special>Values>OK>Esc


Gord Dibben MS Excel MVP