Home

Issue to create Holiday day Tracker

%3CLINGO-SUB%20id%3D%22lingo-sub-848097%22%20slang%3D%22en-US%22%3EIssue%20to%20create%20Holiday%20day%20Tracker%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-848097%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFirst%20of%20all%20big%20thank%20you%20for%20this%20course.%20This%20course%20is%20perfect%20for%20everyone%20and%20it's%20really%20help%20me%20for%20my%20career%20development.%20After%20this%20course%20i%20am%20try%20to%20make%20Holiday%20tracker%20for%20my%20manager%20to%20see%20all%20team%20member%20future%20holiday%20plans%20for%20whole%20year.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EUnfortunately%2C%20I%20have%20some%20issue%20to%20complete%20the%20Holiday%20plans%20tracker.%20As%20you%20can%20see%20the%20image%20of%20my%20excel%20sheets%20then%20you%20find%20that%20there%20is%20three%20sheets%20%3A%3C%2FP%3E%3CP%3E1)%20Main%20file%202)%20Holidays%20Plans%203)%20Key%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIssues%3A%3C%2FP%3E%3CP%3E1)%20How%20to%20create%20the%20macros%20work%20like%2C%20when%20you%20click%20on%20Reserve%20button%20then%20automatically%20Name%20on%20cell%20'A10'%20(%20From%20Holiday%20Plans)%20copy%20and%20paste%20on%20'E5'%20(%20From%20Main%20File)%20with%20selected%20dates%20on%20'B10%20%3A%20AF10'%20(%20From%20Holiday%20Plans)%20copy%20and%20paste%20on%20'F5'%20(%20From%20Main%20File)(%20with%20'ddd%20dd'%20format).%3C%2FP%3E%3CP%3E*please%20note%20that%20data%20should%20store%20by%20cell%20after%20next%20cell.%20Refer%20to%20image2%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E2)%20If%20i%20change%20the%20month%20from%20combo%20box%20(in%20top%20left%20corner)%20then%20automatically%20save%20the%20data%20from%20'Main%20file'%20sheet%20(in%20Reserve%20table)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E3)%20In%20Holiday%20Plans%20sheet%20how%20to%20create%20the%20macro%20button%20for%20create%20PDF%20file%20(Only%20'Main%20File'%20sheet)%20every%20time%20with%20new%20PDF%20file%20name%20and%20also%20save%20in%20desktop.%3C%2FP%3E%3CP%3EI%20am%20glad%20that%20if%20you%20can%20help%20for%20it.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20in%20advance.%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%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F131077i14C198552F83E6A7%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Holiday%20plans%20issue.PNG%22%20title%3D%22Holiday%20plans%20issue.PNG%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F131078iEC0012A3131C5BA7%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image2.PNG%22%20title%3D%22image2.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-848097%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
ashishG1984
Occasional Contributor

Hello,

 

First of all big thank you for this course. This course is perfect for everyone and it's really help me for my career development. After this course i am try to make Holiday tracker for my manager to see all team member future holiday plans for whole year.

 

Unfortunately, I have some issue to complete the Holiday plans tracker. As you can see the image of my excel sheets then you find that there is three sheets :

1) Main file 2) Holidays Plans 3) Key

 

Issues:

1) How to create the macros work like, when you click on Reserve button then automatically Name on cell 'A10' ( From Holiday Plans) copy and paste on 'E5' ( From Main File) with selected dates on 'B10 : AF10' ( From Holiday Plans) copy and paste on 'F5' ( From Main File)( with 'ddd dd' format).

*please note that data should store by cell after next cell. Refer to image2

 

2) If i change the month from combo box (in top left corner) then automatically save the data from 'Main file' sheet (in Reserve table)

 

3) In Holiday Plans sheet how to create the macro button for create PDF file (Only 'Main File' sheet) every time with new PDF file name and also save in desktop.

I am glad that if you can help for it.

 

Thank you in advance.

 

Holiday plans issue.PNGimage2.PNG

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies