Hi
I am currently trying to create a database in excel. So far I have used this tutorial/template (http://chandoo.org/wp/2012/04/02/using-excel-as-your-database/)
Unfortunately, I can not change it to fulfill my requirements.
I am trying to create a database in excel where I, for example, have assignments and names.
I have the different assignments in rows and the names in columns. The purpose is only to have each assignment listed once and then be able to assign one or more people to the assignment by an x.
See attached Excel sheet under data. (Please note that the uploaded excel sheet only is a dummy with no coding.)
Then in a different tab (view) I would like to be able to choose one name or `show all´ in a drop-down menu and then see all the relevant assignments for that name. Also if possible keeping the same formatting as in the data tab.
Furthermore, it should be possible to update the database with new assignments, and if possible print the assignments for the name chosen.
I have earlier tried a simple code that just hid the different columns but every time I added an assignment I had to change the code manually. Therefore it is very important that the database can be updated without any changes to the code.
Thank you in advance for your help!
I am currently trying to create a database in excel. So far I have used this tutorial/template (http://chandoo.org/wp/2012/04/02/using-excel-as-your-database/)
Unfortunately, I can not change it to fulfill my requirements.
I am trying to create a database in excel where I, for example, have assignments and names.
I have the different assignments in rows and the names in columns. The purpose is only to have each assignment listed once and then be able to assign one or more people to the assignment by an x.
See attached Excel sheet under data. (Please note that the uploaded excel sheet only is a dummy with no coding.)
Then in a different tab (view) I would like to be able to choose one name or `show all´ in a drop-down menu and then see all the relevant assignments for that name. Also if possible keeping the same formatting as in the data tab.
Furthermore, it should be possible to update the database with new assignments, and if possible print the assignments for the name chosen.
I have earlier tried a simple code that just hid the different columns but every time I added an assignment I had to change the code manually. Therefore it is very important that the database can be updated without any changes to the code.
Thank you in advance for your help!