Edit macro edits data and adv filte, but not the calendar

[Maddart]

Hello,
This is my camping booking sheet. My issue is with the Edit Booking macro.

Let's use Denis as an example: he is booked for 15 days I can change all the info on status and add/ remove days with amounts

It will update the status, number of days and amounts in the data and the advanced filter and at the top of the bookings tab but not the length of the line on the calendar.

Thanks in advance

PS would it be possible to use cells on first sheet to draw out the site instead of an image and have the lots change color according to the calendar or is that too much? I cropped the image so I could share.

[Joske920]

Hi Maddart,

Why is the line to edit the end date commented in the code
offcourse it wont update if you dont save

in your code

Please Login or Register  to view this content.

remove the '

Please Login or Register  to view this content.

Grtz

[Maddart]

Hello Joske920,

Thank you again, sometimes you can't see it even if it's right there in plain view...

It was a simple fix but seems I needed a fresh view.

Really appreciate the help.