Update prices automatically on a specific date

[jeff2813]

Just wondering if its possible to update prices by inflation on specific dates. As an example, i'd like a loaf of bread at $1 to automatically adjust for a predetermined inflation rate on every Jan 1. I know i can make columns but I'd like only one specific cell to constantly update annually. I have a home inventory and id like the individual items to update yearly to reflect inflation. Thanks

 

[jeff2813]

Hi

 

[alansidman]

Can you show us a sample of your data before and after. Does not need to be many records, but enough to be representative of your worksheet