Dropdown List - Change values when selecting item from dropdown list

[markus2291]

Hey ppl,

I was making an monthly employee plan in excel (workhours,overwork,sickness etc..).

The month can be selected in a dropdown list, when I select another month the weekends,holidays and the amount of days dependent on the month change, so far so good, this is what i'm trying to do now but can't find a way:

Let's say I would be on month january, if I would type in values into the cells, and then switch on the month february, the values would obviously stay, but I'm trying to have the values changing when I change the month too.So i could have a full one year history of an employee and I could check the values from specific months by selecting them in the dropdown list.

Is this even possible ? And if yes, how ?

Kind regards,

Markus

 

[Ingolf]

Hi,

There are more ways to do what you want.
One of them is to create a sheet for each month of the year, and then add the data to the Master sheet. if you select the month of January the data will be brought from the January sheet ...
Another possibility is to create a table for each month (each month will be the sequel to the other) and then to see only the month you want, the rest of the columns to be hidden.

 

[markus2291]

If I would create a sheet for every month would I be able to edit those in the mastersheet ?

 

[Ingolf]

I thought you wanted to view the data in that month in the master sheet.
So what do you want to do? Do you want to write or just visualize?
If you want to enter data, you can do the following:
In the Master sheet you write the data you are interested in during the month, then press a button (VBA code) to create a sheet with the name of that month and copy the data written in the master sheet.
If you just want to visualize, you can do as I said in the previous post.