CODEWITHSUNDEEP
excelvbaexcel-formula
KD23
KD23

Reputation: 1

I require to change the cell formulas to values only when a certain date passes

I have a pivot table on excel that automatically updates with values every day.

I have columns next to the pivot table for EACH DAY that grabs data from the updated pivot table using a simple formula, for example I11-V11.

However, when the date for today passes, i want the cell in the specific column for that date to change to a value i.e be fixed.

Is there a way that this could be done?

image showing snippet of spreadsheet

Upvotes: 0

Views: 618

Answers (1)

teylyn
teylyn

Reputation: 35915

You want a snapshot of the data. Manually, you could copy and paste the data over itself with Paste Special > Values.

You can create a VBA macro for that, but the trigger for the macro would still have to be manual. Because if it is dynamic, once the header date is in the past, any formula will have already updated dynamically and yesterday's values will be gone.

So, either manually copy/paste values (or fire up the macro to do that), or add a date column to the data source, so a formula can associate a value with the correct date.

Upvotes: 1

Related Questions