| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Locking in values
When an amount is entered in column B, column C looks up an array of rates
and does a calculation based on the currency in column A. The challenge is locking in the amount in column C to reflect the conversion on the opening date, as the rates are updated daily. Is the only solution Paste Special? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| row locking, instead of file locking? | Excel Discussion (Misc queries) | |||
| Locking a row | New Users to Excel | |||
| locking formula in cells in without locking whole sheet | Excel Discussion (Misc queries) | |||
| Locking down a tab | Excel Discussion (Misc queries) | |||
| locking data values from links | Excel Discussion (Misc queries) | |||
Hybrid Mode
