VBA not working due to referenced sheet formatting changes

[Maddart]

Hello,
The base template was downloaded from a website with the formula and video help.

I need to adapt it to a campsite so services and amps in different combinations is a must for booking purposes.

All was working fine till I added rows and columns to the booking sheet.
Read the code and changed cell reference values to new locations, so I think.
Booking in the list stopped showing up on the bookings sheet calendar

I am thinking that the code has a number of offsets and I am not understanding the function, so not fixing.

I never managed to get the edit booking to work, the VBA is in the workbook.
Lookup, delete and add bookings all stopped working since my modifications.
Clear is to clear the info on the booking sheet.
+7 and -7 work fine as does the calendar.

Interface and invoice can be done at a later time through Commercial Services

Thank you

[Joske920]

Hi,

The mistake is in the bookings part

change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

and all works again
or download the book back
i didn't tough the edit part

[Maddart]

Thanks for the help.
Really appreciate it.

I will keep looking into the edit booking part

[Maddart]

Hello again,
Getting closer to the completed work.
The edit booking macro - button is semi-working:
I can lookup a booking and change the status -to or from paid cancelled unconfirmed etc. (color change)
If I add or remove days for the stay, they update in my data tab in data and data advanced filter but not in my calendar.

Pretty sure it's something in my booking that is not updating.

hope you can help

Thank you

[Joske920]

Hi,

You need to add all the cells you write to the data in your edit code then it does update

Please Login or Register  to view this content.

[Maddart]

Hello Joske920,

Thank you very much this is what I needed.

Wish you the best for the new year and years to come.