![]() ![]() 2: Set up data validation drop down list on the first cell for automatic rolling If you prefer, name this range as “ lstMonths“. To set up such dynamic rolling months in Excel, just follow these simple steps: 1: Create a list of all the monthsĮnter the month names in a bunch of cells (Tip: Just enter the first month name and then click at the bottom right corner of that cell and drag to get all the other month names). ![]() Today we are going to learn how to set up automatic rolling months in Excel. Gantt Charts to change the project start dates with ease. This type of setup is quite useful as it lets us change the starting month very easily. Often when we are making spreadsheets for forecasting or planning we would like to keep the starting month dynamic so that rest of the months in the plan can automatically rolled.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |