Remove/disable lookups and formulas when a date has passed in each row.

[Mhay5656]

Hi,

I have a spreadsheet that has lookups and formulas that retrieves information from another sheet , what I would like to do is stop or disable the lookups automatically when a date in the row has passed the current date. IF this could be done by a macro automatically.

The reason being is that I need to update the data in the lookup sheet quite regularly, some of the data will change or is removed which will error the previous entries on the main sheet, so what I need is a way to stop or disable the lookups so my old data does not change, or Saves values macro .

Example - before updated data this what it looks like in my spreadsheet

showing in a Row is - John 27/11/17 (current date) $50,000.00 (I don't want this to change)

after I have updated the rate has changed

John 27/11/17 $60,000.00 (need to keep the $50K and not update)

After up date if John's details are no longer showing I end up with #n/a#

and need the details above to stay without the formulas etc "John 27/11/17 (current date) $50,000.00"

Many thanks