Build an Automatic Calendar with Macro in Excel

แชร์
ฝัง
  • เผยแพร่เมื่อ 2 ธ.ค. 2024

ความคิดเห็น • 164

  • @luci1242
    @luci1242 ปีที่แล้ว

    Thank you!!!! This is exactly what I need to make things so much easier. Last year, I made individual worksheets for each month. At some point, I decided to keep a running total of everything I was capturing. I found myself having to input the information into ALL of the sheets to keep the formula accurate. So much easier!!!

    • @FredericLEGUEN-Excel
      @FredericLEGUEN-Excel  ปีที่แล้ว

      Hi Luci, thanks a lot for your message. I'm glad if I could help you and save your time.
      I have created a similar calendar but this one save the data when you move to another month. The file cost USD 9.99$. Will you be interested by such program (I will make the video tomorrow)

  • @tayamiruo7200
    @tayamiruo7200 3 ปีที่แล้ว +14

    I appreciate your effort in this video. When I finished the calendar, I put in information in a month but when I change the month and return to the month I put in the information, I don’t find the information. Please help, thank you.

    • @mohsnig
      @mohsnig 2 ปีที่แล้ว +1

      Hi there: I am having the same issue, did you find the solution to it?

  • @354viswanath
    @354viswanath 4 ปีที่แล้ว +4

    Thank you a lot for excel auto calendar making. After preparing the calendar, how do we able to see whole 12months calendar in single sheet at a time without selecting the picklist and go to every month by month?

  • @rkelvinruban9095
    @rkelvinruban9095 3 ปีที่แล้ว

    Very Very Clear Explanation and to the point Explanations of what is needed

  • @Shaytouna
    @Shaytouna 5 ปีที่แล้ว +2

    one of the best and most useful videos, thank you sooooo much I would have given a SUPER LIKE for this

  • @dig5166
    @dig5166 5 ปีที่แล้ว +1

    Thank you for a very clear and easy to follow tutorial. I was able to follow along and create an attendance log of my own. It was a great learning experience. I greatly appreciate it.

  • @fraubiene
    @fraubiene 5 ปีที่แล้ว +1

    Thank youuuu so much!!!! I’ve been looking this for AGES!!! Very helpful guidance! Please teach more! Love your tutorials

  • @ymangune
    @ymangune ปีที่แล้ว

    Great video! Very clear and I followed it properly. I have a timesheet but not automated and now it is, thanks for this.

  • @ismaelkourouma5558
    @ismaelkourouma5558 2 ปีที่แล้ว

    Excellent ! Meme après 4 ans, toujours extrêmement utile. Merci Frédéric !

  • @edgeui
    @edgeui 6 ปีที่แล้ว +10

    Great stuff! Is it possible thou to save data that was filled in lets say October, to stay locked in October? The current macros cleans the previous content, and if you switch to November and then go back to October it will clean any data that was filled inside that month. Thank you!

    • @RaiyanaRR
      @RaiyanaRR 5 ปีที่แล้ว

      Евгений Мейран did you solve it yet?

    • @dejanastupar6777
      @dejanastupar6777 5 ปีที่แล้ว

      Did you solve it?

    • @dig5166
      @dig5166 5 ปีที่แล้ว +4

      Hello. I was able to keep the data by deleting the lines in the macro relating to the deletion of the entries. I then copied the sheet to create individual sheets for each month within the workbook. Then you just need to run the saved macro within each of the sheets, and it takes care of the extra columns you don't need. Hope this is of help to you.

    • @ntombidada2424
      @ntombidada2424 3 ปีที่แล้ว

      @@dig5166 please post a tutorial with your explanation please

    • @jupiterhaha
      @jupiterhaha 3 ปีที่แล้ว

      @@dig5166 That's not automatic. You have to do a bunch of extra steps. You didn't solve anything.

  • @phothar87
    @phothar87 4 ปีที่แล้ว +3

    I done it today. However, I got problem with clear contents. example.. I add data in Feb and I go to Marc the contents are cleared but once I go back Feb, the data on Feb is cleared too.. It's suppose to remain right? please advice ... Thanks.

  • @jimicapaulalozano49
    @jimicapaulalozano49 2 ปีที่แล้ว

    Thank you for the very easy to follow instruction! I really loved it.

  • @margiemcnair34
    @margiemcnair34 5 ปีที่แล้ว

    Thank you for creating and sharing the process step by step.

  • @linan3656
    @linan3656 4 ปีที่แล้ว +3

    I love it thank you, but how can I set VBA to save all data for each month without deleting it when I go to another month or year

    • @timothyrolston7837
      @timothyrolston7837 4 ปีที่แล้ว +1

      Hi Lina, I am looking the same thing. Did you get an answer to this one?

    • @linan3656
      @linan3656 4 ปีที่แล้ว

      Timothy Rolston
      Yeah I did and you can find it here
      You need to follow the same steps on VBA
      th-cam.com/video/iyr9WIyxlJc/w-d-xo.html

    • @ntombidada2424
      @ntombidada2424 3 ปีที่แล้ว

      @@linan3656 please share how you retain data of previous month calendar.

  • @Roger-ou8je
    @Roger-ou8je 4 ปีที่แล้ว +4

    I love this tracker but I have a question. When you switch to next month, the data gets deleted, but when your rturn to the previous month, the data entered is gone as well. Is there a way to program it so that when you switch to new month data clears but stays saved in the previous month?

    • @ryanjohnston9642
      @ryanjohnston9642 3 ปีที่แล้ว

      Did you get anywhere with this question? I've just built this calendar myself but need a way to preserve the data entered into each calendar.

    • @jupiterhaha
      @jupiterhaha 3 ปีที่แล้ว

      @@ryanjohnston9642 Exactly. This video is somewhat a dud without that capability.

    • @bearclaw2500
      @bearclaw2500 2 ปีที่แล้ว

      @@jupiterhaha have you guys figured out the trick? Stuck on the same scenario.

    • @mohsnig
      @mohsnig 2 ปีที่แล้ว

      Anyone got the solution for this? Stuck on same thing

    • @jordanrich1877
      @jordanrich1877 2 ปีที่แล้ว

      @@mohsnig How did you guys create the loop? that part wasnt clear to me

  • @raidalkhalaf4518
    @raidalkhalaf4518 4 ปีที่แล้ว

    Good thing is to clear data after changing the year or the months. Good job Sir.

    • @bebeautifulbeu3259
      @bebeautifulbeu3259 3 ปีที่แล้ว

      I have applied the same but my previous month data also getting cleared. Can you advise how to fix it?

    • @rahafm6569
      @rahafm6569 8 หลายเดือนก่อน

      @@bebeautifulbeu3259 do u know now how to fix it😢😢

  • @fvieiraaa
    @fvieiraaa 5 ปีที่แล้ว +2

    I have the same thing with not keeping it’s data and overwriting to the next month.. is there a macro for that too?

    • @FredericLEGUEN-Excel
      @FredericLEGUEN-Excel  5 ปีที่แล้ว

      Yes, but the macro is too complex to be shared in a tutorial video. It's a real computer programming project

  • @sandrinegauder4071
    @sandrinegauder4071 2 ปีที่แล้ว +1

    Merci, très utile ! auriez-vous une astuce pour garder les données pour chaque mois? ex, je passe au mois d'aout, les données juillet s'effacent.

    • @FredericLEGUEN-Excel
      @FredericLEGUEN-Excel  2 ปีที่แล้ว

      Dans la description de la vidéo je renvois vers un article qui explique le détail du code, dont le point que vous soulevez.

  • @learningexcel7
    @learningexcel7 ปีที่แล้ว

    Hi please can you do a video explaining how to retain data entered in each month. I get it's more complex but would be very helpful to learn. Thanks!!

    • @FredericLEGUEN-Excel
      @FredericLEGUEN-Excel  ปีที่แล้ว

      Doing a video? Impossible because it took me 3 weeks to create the tool to do the job. In the description of the video, you have the link to download the workbook to save and recall the data. You can also read the article that explain all the feature of the workbook

  • @audiofrank6747
    @audiofrank6747 3 ปีที่แล้ว +1

    Thanks a lot, very appreciated it!

  • @ShireneElise
    @ShireneElise 2 ปีที่แล้ว

    Hi, fantastic tutorial, thank you! Do you have a tutorial or any guides on writing the formula list for public holidays? I am based in Australia and would like to include them.

  • @JAYS040787
    @JAYS040787 3 ปีที่แล้ว

    Thank you very much for your informative video, this helped alot with making my own personal calender.

  • @georgelittle4334
    @georgelittle4334 2 ปีที่แล้ว +1

    Looks great, but unfortunately I couldn't find a way around it not saving any information in the cells - so it was ultimately useless.

  • @dandanakan0
    @dandanakan0 4 ปีที่แล้ว +1

    Thank you very much, found it extremely useful.:)

  • @tales_by_lens
    @tales_by_lens 3 ปีที่แล้ว +1

    Hi thank you! I am here because I was using Validation before and that is not too helpfull. Can you please help me?? I am having hard time with Macros, in my sheet I am using Columns for Employee names and rows for Dates, how would I code that. Thank you!!

    • @gasing6108
      @gasing6108 3 ปีที่แล้ว

      same like me. but it appear error. i dont know how to define it, to make it correctly changes by the month

  • @craigfisher4918
    @craigfisher4918 3 ปีที่แล้ว

    Is there a video on how to create the Public Holiday spreadsheet ?

  • @yogalekshumimarimuthu2173
    @yogalekshumimarimuthu2173 2 ปีที่แล้ว

    Thank you so much, i have one question , how to include public holiday for several country?

    • @FredericLEGUEN-Excel
      @FredericLEGUEN-Excel  2 ปีที่แล้ว

      Ouch, this question is tough. Not easy to reply without seeing the context.

  • @jaquignolle
    @jaquignolle 2 ปีที่แล้ว

    Hello! Thank you so much for this very helpful tutorial. I just have one tiny issue and hope that someone could help point me in the right direction: I would like to share this excel sheet with my teammates so that we can keep track of everyone's vacations. When I want to add "x"s in the month of January they also appear in all the other months. Is there a way for the "x"s to just show on the month we are adding them in? Thanks :)

  • @sundarm8245
    @sundarm8245 3 ปีที่แล้ว

    Thank you for the ideas. While we input the numbers in Feb and move to Mar - it is clear content, but when we come back to Feb again values become clear content. how to make fix the values in each month ???????

    • @FredericLEGUEN-Excel
      @FredericLEGUEN-Excel  3 ปีที่แล้ว

      It's something possible but it's much more complex to build because you must manage the process to store somewhere the previous data. The best is to use Planner

  • @srinathd
    @srinathd 4 ปีที่แล้ว +3

    Awesome Tutorial sir. Excellent job... i have a question, how do i get back my entered data month-wise or year-wise when i move to February to January or year to year,
    that means when i move from January to February content to be cleared but when i move to February to January i want to retain my January data :)

    • @johnmarimarcelo
      @johnmarimarcelo 3 ปีที่แล้ว

      @excelexercice same question. how can i retain the data in a certain month?

    • @ryanjohnston9642
      @ryanjohnston9642 3 ปีที่แล้ว

      @@johnmarimarcelo - did you find a solution to this problem? I figure that data entered into any given month will need to be stored in another table someplace. This begs the question: when we switch back to any given month, how does the calendar pull data from that month's storage table and how does this read/write action get managed?

  • @fvieiraaa
    @fvieiraaa 5 ปีที่แล้ว +4

    There is no point of creating this calendar if you’re going to copy paste them to have multiples that have data inside...

  • @anghyy
    @anghyy 5 ปีที่แล้ว +1

    Hi, Thanks for sharing! very clear :) but how to apply the bank holidays formula when the employees of a same team are leaving in different countries? As an example, I have a team of 7 remote worker dispatched all over the world, how can I apply the bankholiday for each? Thanks in advance for your help

  • @radeknikodem700
    @radeknikodem700 2 ปีที่แล้ว

    Can I download this somewhere? I mean
    the whole folder.

  • @marvicreano2394
    @marvicreano2394 2 ปีที่แล้ว

    This is very helppul however I wish he shared how to retain the data from previous month.

  • @omprasadmahapatro2649
    @omprasadmahapatro2649 4 ปีที่แล้ว

    Hi i want to do the same.i am using Microsoft 2007.i tried a lot but stock in a scenario.when i select january or any other month or year from dropdown menu,in A1 it is showing as same.Not as 1,2,3.Don't know what to do.
    Please help me.
    Thank you

  • @abhishekvirgo
    @abhishekvirgo 4 ปีที่แล้ว

    Need your support if we have alternate Saturday off than how can we select conditioning format in that file please reply

  • @minyunii1511
    @minyunii1511 2 ปีที่แล้ว

    Thank u so much bro!

  • @sandyk3264
    @sandyk3264 4 ปีที่แล้ว +1

    Nice one! But whats the sense uf it deletes whole data everytime u change month. Not practical

  • @molinaser28
    @molinaser28 ปีที่แล้ว

    Hi brother, Thank you for the tutorial,
    I am having a bit of an issue, everytime i change the month the content is deleted. but I want to keep the content as a record form previous months.
    can you please help me,
    Thanks

  • @mohitbahl2447
    @mohitbahl2447 ปีที่แล้ว

    Thank you!!
    I have got all you said, but i am facing an issue with the "Clear Content".
    When I fill-in the cells for Jan and move to Feb and again move back to jan, the data entered is lost. Is there a way to retain the previous months data also along with getting clear cell for next month?

    • @FredericLEGUEN-Excel
      @FredericLEGUEN-Excel  ปีที่แล้ว +1

      Next week, you could download the program to save your data. The program is nearly finish and we have more tests to do before to share the link.

    • @FredericLEGUEN-Excel
      @FredericLEGUEN-Excel  ปีที่แล้ว

      Hi, Finally it was longer than expected (many little bugs to correct) but now the calendar with saving data is done. In the description of the video, you have the link for the file and the link for the explanation

  • @mhnbharat4814
    @mhnbharat4814 2 ปีที่แล้ว

    Hi i missed something. The data got erased after changing the new month. but its not able to record the previous month attendance. how to do that? if possible please share that too.

  • @MickV08
    @MickV08 3 ปีที่แล้ว

    Thank you for this! Appreciate it ☺️ but how to save this month’s data November. Thank you.

    • @FredericLEGUEN-Excel
      @FredericLEGUEN-Excel  3 ปีที่แล้ว

      That's not possible or you need to create a long and complex vba code

  • @jordanwilliams5034
    @jordanwilliams5034 3 ปีที่แล้ว

    How did you plug in the formulas for public holidays?

  • @darktower74
    @darktower74 4 ปีที่แล้ว +2

    I used to think Photoshop experts were the bomb.... Excel is like high math.

  • @saluma.m.el-harthy9265
    @saluma.m.el-harthy9265 4 ปีที่แล้ว +1

    Fantastic and Thanks

  • @AkashkumarRaushan
    @AkashkumarRaushan 9 หลายเดือนก่อน

    Thank you !!
    I have a few questions.
    How to access previous months' data?

    In this video I did not learn how to store previous months data. So please help me.

    • @FredericLEGUEN-Excel
      @FredericLEGUEN-Excel  9 หลายเดือนก่อน

      With this demo, you can't.
      But in the description of the video, you have the link to download the workbook which save all the data and re-display them for the previous month

  • @kishan999ful
    @kishan999ful 5 ปีที่แล้ว +1

    Awesome buddy Thank you so much.

  • @ViszlaBoss
    @ViszlaBoss 2 ปีที่แล้ว

    Can it be set where the previous months data is not lost but still complete if you move from month to month? Thanks

    • @FredericLEGUEN-Excel
      @FredericLEGUEN-Excel  2 ปีที่แล้ว

      No, it's not possible easily. It's possible but with a lot of code

    • @ViszlaBoss
      @ViszlaBoss 2 ปีที่แล้ว +1

      @@FredericLEGUEN-Excel Thank you for the reply. Great video. Even without saving the data I learned a lot.

  • @jasonMartinez-n1h
    @jasonMartinez-n1h ปีที่แล้ว

    How do I create a calendar set up just like this, but without weekends?

  • @lordtnarg1085
    @lordtnarg1085 5 ปีที่แล้ว +1

    hi there! video was good but do you know how can i retain the data on the calendar? say i have schedule in January 8 2019, it should stay at the date but whenever i go to other dates and go back, the data is also gone?? please help

    • @RaiyanaRR
      @RaiyanaRR 5 ปีที่แล้ว

      Grant Philip Gloria did you solve it yet?

    • @lordtnarg1085
      @lordtnarg1085 5 ปีที่แล้ว

      @@RaiyanaRR not yet, do u know some workarounds? I'm just a newb in Excel that's why these videos help me

    • @sargecmulackal9591
      @sargecmulackal9591 5 ปีที่แล้ว

      I have the same issue, got almost everything correct except the issue you are stating, do not know a fix for this

    • @wurihandayani2465
      @wurihandayani2465 5 ปีที่แล้ว

      I also have the same problem, did you solve it?

    • @sebastianbellini9512
      @sebastianbellini9512 5 ปีที่แล้ว +1

      Has anyone found the solution to this issue?

  • @MrSebLolo
    @MrSebLolo ปีที่แล้ว

    Hello nice video! What about with no Macro? Do you have a video? Thanks

  • @ayemblest3229
    @ayemblest3229 7 หลายเดือนก่อน

    Hello. how do you plug in for an every other weekend days off for employees?

  • @gasing6108
    @gasing6108 3 ปีที่แล้ว

    I tried but i got some error bout VBA. I use ROW instead of column. so how to define it?
    Sub Macro1()
    '
    ' Macro1 Macro
    '
    '
    Rows("40:42").EntireRow.Hidden = True
    Rows("41:43").EntireRow.Hidden = False
    Range("B13:42Y").ClearContents ---- got error with this

    End Sub

    • @pradeepkumarkuwait
      @pradeepkumarkuwait 3 ปีที่แล้ว

      I have same problem , how can make this calender on Row basis?

  • @ramsundarparamasivam1965
    @ramsundarparamasivam1965 3 ปีที่แล้ว

    Every thing is going fine but In the last macro commands, I could not get create a loop for the final code .. please share how to create a loop

    • @FredericLEGUEN-Excel
      @FredericLEGUEN-Excel  3 ปีที่แล้ว

      Have you checked the explanation of the code in the description of the video? Because it's impossible for me to give you an explanation why you can loop on the last columns

  • @snyeder
    @snyeder 5 ปีที่แล้ว +1

    When you create a loop half the screen went blank. Please explain how did you create the loop?

    • @mokfrans
      @mokfrans 3 ปีที่แล้ว

      Hi .... were you able to get the response?

  • @muhammadfaizal6960
    @muhammadfaizal6960 ปีที่แล้ว

    Hi , i wanted to create something similar to this but in Google Sheet. not as calendar but only as a table. what i aim is whenever i select different month, different data will appear. That also data that i have inputed manually before. Can anyone help please?

  • @flashxml-flashxml
    @flashxml-flashxml ปีที่แล้ว

    How can I change name from table to other language calendar? Friday to become Vineri!

  • @dorischoo
    @dorischoo 3 ปีที่แล้ว

    What if we want to eliminate weekends completely and keep data history.

  • @Kuulaxi
    @Kuulaxi 3 ปีที่แล้ว

    Hey! Is it possible to show week number above the date? Like it goes from monday to friday and above that is week number? Thanks in advance

    • @FredericLEGUEN-Excel
      @FredericLEGUEN-Excel  3 ปีที่แล้ว

      Good question, this will be the subject of another video 😀

  • @ocean99a
    @ocean99a 5 ปีที่แล้ว +1

    Dear Sir
    In the automatic calendar, February has 28 days so how to hide the remaining cells.
    thanks a lot

  • @caloupascalou5848
    @caloupascalou5848 4 ปีที่แล้ว +1

    Excellent l'ami !

  • @tomcowsert8962
    @tomcowsert8962 5 ปีที่แล้ว +1

    Also, how does it account for Leap Years?

    • @FredericLEGUEN-Excel
      @FredericLEGUEN-Excel  5 ปีที่แล้ว +1

      It works because the test of the macro is based on the value of the month. So even for a leap year, the test will work

  • @daviduzel7541
    @daviduzel7541 4 ปีที่แล้ว

    Thank you very much, you are GREAT! This video was really useful for me..please could you help me? How can I keep 1 for each month? When I switch the month the data has lost. I will be grateful for your answer :-)

    • @FredericLEGUEN-Excel
      @FredericLEGUEN-Excel  4 ปีที่แล้ว

      This is not simple and it's a real development project. There is so many situation and rules that it's impossible to do a tutorial video for that

    • @cypherecon5989
      @cypherecon5989 2 ปีที่แล้ว

      @@FredericLEGUEN-Excel A video about would be cool even if it is difficult!

  • @abdullaalshaikh5528
    @abdullaalshaikh5528 3 ปีที่แล้ว

    Very good an clear

  • @SatishKumar-bz8fo
    @SatishKumar-bz8fo 5 ปีที่แล้ว

    How to set shift pattern in this file

  • @pradeepkumarkuwait
    @pradeepkumarkuwait 3 ปีที่แล้ว

    How to make same calander on Row basis

  • @mahaboobhossain5076
    @mahaboobhossain5076 4 ปีที่แล้ว

    brother i need this project video file

  • @ashantie50
    @ashantie50 5 ปีที่แล้ว

    I did this exact thing and my macro is only holding up to 28 days rather than giving me the days of each month. What should I do?

    • @FredericLEGUEN-Excel
      @FredericLEGUEN-Excel  5 ปีที่แล้ว

      Certainly because your date are not in row 6 or the result of the selected month is not in A1

  • @shorthli
    @shorthli 5 ปีที่แล้ว

    the date formula isn't working on my excel, when I put exactly as it shown in video it says that formula isn't correct =DATE(A2+2018,A1,1). It says that input not enough criteria

    • @FredericLEGUEN-Excel
      @FredericLEGUEN-Excel  5 ปีที่แล้ว

      What do you have in A2and A1 ? If it's empty, it can't work

  • @Spirit612
    @Spirit612 2 ปีที่แล้ว

    I noticed that after this tutorial was put online 3 years ago that the same comments/questions being asked that I have still remain unanswered by the creator. Hmmm! From the viewpoint of a noob, the other issue is the commands your using when you highlight cells and extend the data - I don't know or see how you're doing it.

  • @SatishKumar-bz8fo
    @SatishKumar-bz8fo 5 ปีที่แล้ว +1

    How to download this file

  • @ntombidada2424
    @ntombidada2424 3 ปีที่แล้ว

    Can someone please help me how to retain data of previous month please

  • @SimranjeetSingh11
    @SimranjeetSingh11 3 ปีที่แล้ว

    How do I download this? There is no link on your website!

    • @FredericLEGUEN-Excel
      @FredericLEGUEN-Excel  3 ปีที่แล้ว +2

      I haven't share the workbook, it's more profitable to do it yourself 😉

  • @cloudnine009
    @cloudnine009 3 ปีที่แล้ว

    But why when I add data to one month and change the month and go back the previous data are cleared as well, I just want the information to be saved and not giving me clear content every time I change the month

    • @FredericLEGUEN-Excel
      @FredericLEGUEN-Excel  3 ปีที่แล้ว

      It's not the purpose of the video. Stored the previous values and reloaded them it's really not easy with Excel and Excel isn't design for that

  • @jamesleleji9470
    @jamesleleji9470 2 ปีที่แล้ว

    Can this be replicated on goggle sheets?

  • @chaoticwisdom4312
    @chaoticwisdom4312 4 ปีที่แล้ว

    How did you format the holiday sheet?

    • @FredericLEGUEN-Excel
      @FredericLEGUEN-Excel  4 ปีที่แล้ว

      I don't understand your question. "Format the holiday"? Do you talk about the date format or How I have build the formulas?

    • @chaoticwisdom4312
      @chaoticwisdom4312 4 ปีที่แล้ว

      @@FredericLEGUEN-Excel in the few seconds that I was able to view the holiday page, I noticed that there was alot there. I wanted to know was there any code, or special function that you use on this page for any reason. Also can you explain how I can auto populate the employees to a work place positions chart?

  • @93rifaz
    @93rifaz 4 ปีที่แล้ว

    Can you send me the code to hide the data entered with macro

    • @FredericLEGUEN-Excel
      @FredericLEGUEN-Excel  4 ปีที่แล้ว

      In the description of the video, you have the link to the article and also another article for the explanation of the code

    • @93rifaz
      @93rifaz 4 ปีที่แล้ว

      excelexercice
      If I change the month the entered values on particular month gets deleted can you help on this.

  • @amirwealth
    @amirwealth 5 ปีที่แล้ว

    How can put from date 26 to 25 every month pls make a video or formula pls

  • @Purando
    @Purando 3 ปีที่แล้ว

    My visual basic didnt open what to do its blank

  • @praveenpaul3846
    @praveenpaul3846 5 ปีที่แล้ว +1

    . Yes. I am facing the same problem. Can we retain the data when we go back to the previous content??

    • @dig5166
      @dig5166 5 ปีที่แล้ว

      Hi. I got past this issue by creating an individual sheet for each month, editing the macro and erasing the last lines which erased the data, and then running the macro in each of the sheets in the workbook. Hope this helps.

  • @KeshKOfficial
    @KeshKOfficial 4 ปีที่แล้ว

    How do I loop the macro? The video skipped that part

    • @FredericLEGUEN-Excel
      @FredericLEGUEN-Excel  4 ปีที่แล้ว

      Loop the macro? I don't understand
      The link to the code is in the description to the code

    • @KeshKOfficial
      @KeshKOfficial 4 ปีที่แล้ว

      excelexercice at 20mins 36seconds you said you are going to create a loop? How do I do that?

    • @sonilante
      @sonilante 2 ปีที่แล้ว

      @@FredericLEGUEN-Excel Hello, thank you very much for this video.
      I have the same problem. I dont have the ,,makro text" of a loop.
      After changing the options in excel and returning back to Visual Basic. There is still the same sentence.
      May I write the new one by myself or I am wrong in some step?
      Thank you. Soňa

  • @fortalezafracao155
    @fortalezafracao155 5 ปีที่แล้ว

    this eight number in the code reference which object?

  • @SuryanaKassimFamily
    @SuryanaKassimFamily 2 ปีที่แล้ว

    Salam sejahtera... Nak tanya...
    Saya buat semua berhasil... Tetapi kenapa maklumat di setiap hari hilang bila kita tukar bulan dan tahun

  • @snyeder
    @snyeder 5 ปีที่แล้ว

    at duration 20:35 onwards to 20:37 the screen goes blank

    • @FredericLEGUEN-Excel
      @FredericLEGUEN-Excel  5 ปีที่แล้ว

      On the description of the video, I give the link to the page with all the explanation AND THE CODE

  • @ZIDANOBAMA
    @ZIDANOBAMA 4 ปีที่แล้ว

    SUPER HEROOOOOOOOOOO. THANKS ALOT, WILL YOU PLEASE WITJOUT MICRO???♥

  • @chrisalty645
    @chrisalty645 4 ปีที่แล้ว

    The calendar is off no use if can't save the data in the months.

    • @FredericLEGUEN-Excel
      @FredericLEGUEN-Excel  4 ปีที่แล้ว

      Because it's not the purpose of the video. What you ask is too complex and need 2 or 3 days of development

    • @bob242000
      @bob242000 4 ปีที่แล้ว

      @@FredericLEGUEN-Excel is this information available on your channel or online anywhere? It would be a massive help. Thanks

  • @janaliptakova9228
    @janaliptakova9228 4 ปีที่แล้ว

    Very great video as well the teacher. But I would like to as for a macro code when I would like that the data stay saved for one month when I change to next month (not clear the content or same data for all months). The second think - I tried to macro code for rows, but I have mistake somewhere - Can you do me a favor. Maybe it can be inspiration for you to create new video for us :)
    'For
    Row_Number = 36 To 38
    If Cells(2, 1) = Month(Cells(Row_Number, 8)) Then
    Rows(Row_Number).EntireRow.Hidden = True
    Else
    Rows(Row_Number).EntireRow.Hidden = False
    End If
    'Next
    Range("C8:E38").Select
    Selection.ClearContents
    End Sub

    • @jordanrich1877
      @jordanrich1877 2 ปีที่แล้ว

      I am having the same issue. Have you found the solution? He wasn't clear on how to create the loop

  • @sheikahamed1754
    @sheikahamed1754 21 วันที่ผ่านมา

    How to create a public holiday

  • @bacem_ch
    @bacem_ch 3 ปีที่แล้ว +1

    merci

  • @bashiramarkhail
    @bashiramarkhail 5 ปีที่แล้ว

    thanks but macro (hide & unhide of last columns not working when I applied)

    • @FredericLEGUEN-Excel
      @FredericLEGUEN-Excel  5 ปีที่แล้ว +1

      It should ! Nothing complex with the macro honestly. If you have respected the position of the cells (rows and columns), it works

  • @markerbok3863
    @markerbok3863 2 ปีที่แล้ว

    helpfull

  • @robertreed4337
    @robertreed4337 2 ปีที่แล้ว

    Excel lent