Hi all,
I would like to take the formulas in a cell and convert that to a value based upon the current date - meaning everything older than today is just a number, not a formula.
Background: This is a productivity report where completed tasks and hours are manually entered at the end of business and then run through a bunch of pivot tables. The dashboard page does a bunch of GETPIVOTDATA and everything is working like it should.
However, we have a separate SQL that gives me real-time data and this is the data that I would like to see in the dashboard for today (the report doesn’t show me older than today or else the update would simply take too long and bog down the server.
So what I need is a macro that will compare dates and anything older than today will be converted from a formula to a number.
Dates are in row 1
Data is in rows 2- 50
In order to make it easy I've attached a dummy file with just one sheet and very basic formulas. It's the principle I'm interested in.
I’ve tried to do the magic myself, but just can’t get it done and none of the macros I’ve found do what I want.
I would appreciate help here.
Cheers
Bookmarks