To All readers,
In my Excel workbook I want to collect all dates out of a database for reservations. I managed to do so, but i have problems with the formulas when the actual time has expired.
In my workbook on Sheet1 a VBA module gives me the data where my house has "no reservation" in F1. With the formula in e.g. C4 it counts if the date in B4 exists in the list of the data in F1. When true it gives a "1" in C4. With the formula in D4 it counts the days for ''no reservation''.
This works fine.
The problem is that after today the past data in F1 has gone from the list (the reservation system doesn't count the days of reservation in the past) and the formula in C4 does not recognize the right data anymore. It changes the outcome of the formula from "1" to "0". So all the data before today will turn into "0" and D4 will not be filled.
What I would like to have is a Macro - or whatelse - which copy the data extracted by my formula in e.g. C4 or D4 to Sheet2 (Formula to Value) so the data can be saved before it turn into "0" by expired date.
I've searched plenty of possibilities in Google and tried several VBA tricks but I can't find a solution that works for me.
P.S. I don't have much experience with programming in VBA, but in the meantime I can understand some language in it.
Does anyone have a working solution for me?
Thanks in advance for responding!
I'll send an attachment of the Excel file.
reservation holiday home.xlsm
VBA Starter
Bookmarks