| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
can an array update only once?
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! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
can an array update only once?
Either freeze the inputs or place the formulae with values.
-- Gary's Student "jmomorrison" wrote: 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! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
can an array update only once?
Yes, that's what I would like to do, but how please?
Thanks "Gary''s Student" wrote: Either freeze the inputs or place the formulae with values. -- Gary's Student "jmomorrison" wrote: 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! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
can an array update only once?
Copy the range, then in place EditPaste SpecialValuesOKEsc
Gord Dibben MS Excel MVP On Wed, 22 Nov 2006 11:12:01 -0800, jmomorrison wrote: Yes, that's what I would like to do, but how please? Thanks "Gary''s Student" wrote: Either freeze the inputs or place the formulae with values. -- Gary's Student "jmomorrison" wrote: 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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find value in array | Excel Worksheet Functions | |||
| macro | Excel Discussion (Misc queries) | |||
| Display an array of references | Excel Worksheet Functions | |||
| defintion of array function | Excel Discussion (Misc queries) | |||
| VBA Import of text file & Array parsing of that data | Excel Discussion (Misc queries) | |||
Linear Mode
