Help on a VBA Code please.....

%3CLINGO-SUB%20id%3D%22lingo-sub-3312599%22%20slang%3D%22en-US%22%3EHelp%20on%20a%20VBA%20Code%20please.....%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3312599%22%20slang%3D%22en-US%22%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHI%20All%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20taking%20a%20look%20at%20this%20post%2C%20I'm%20stuck%20on%20trying%20to%20code%20this%20scheduler.%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20when%20you%20select%20a%20date%20on%20the%20Calendar%2C%20You%20then%20select%20the%20time%20(Column%20N)%20and%20then%20you%20can%20fill%20the%20(Q%3AW%20Column)%20with%20booked%20appointments.%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20made%20it%20so%20that%20when%20you%20select%20the%20date%20and%20a%20time%2C%20It%20shows%20in%20the%20(Q3)%20row.%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20so%20stuck%20on%20how%20to%20code%20this%20so%20that%20it%20creates%20its%20own%20saves%20on%20a%20hidden%20workbook%20but%20still%20summarizes%20the%20booked%20appointments%20that%20have%20been%20inputted.%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20also%20hoping%20that%20there%20is%20a%20way%20to%20save%20it%20in%20the%20datasheets%20in%20an%20order%20that%20is%20%22followable%22%20.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20attached%20a%20screen%20shot%20below.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20Help%20would%20be%20greatly%20appreciated.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22DexTrex_0-1651688912759.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F369247iD04817E9F714B153%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22DexTrex_0-1651688912759.png%22%20alt%3D%22DexTrex_0-1651688912759.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3312599%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New 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