Help on a VBA Code please.....

Copper Contributor

 

HI All, 

 

Thanks for taking a look at this post, I'm stuck on trying to code this scheduler. 

So when you select a date on the Calendar, You then select the time (Column N) and then you can fill the (Q:W Column) with booked appointments. 

I've made it so that when you select the date and a time, It shows in the (Q3) row. 

I am so stuck on how to code this so that it creates its own saves on a hidden workbook but still summarizes the booked appointments that have been inputted. 

I am also hoping that there is a way to save it in the datasheets in an order that is "followable" .

 

I've attached a screen shot below.

 

Any Help would be greatly appreciated.

 

DexTrex_0-1651688912759.png

 

0 Replies