Hi All,
I've recently seen the periodic table by Jordan Golmeier that uses the rollover technique.
I'd like to incorporate something similar in work but I'm not vastly experienced in excel and have very little experience with VBA.
I would like help on how to hover over the cell and make it highlighted like in the main body of the periodic table.
Also how do you create the large box at the top which populates with various information from the data tab?
Finally how to create either drop down menus/filter selection that can be clicked to highlight all the cells with the relevant information?
Does anyone have a video or step by step guide on how the periodic table was created or could point me in the direction of how I could start to learn how to try and create something similar. I know it is quite a complicated task for someone who is not an experienced excel user, but if I could get the idea to work it would really help.
I've recently seen the periodic table by Jordan Golmeier that uses the rollover technique.
I'd like to incorporate something similar in work but I'm not vastly experienced in excel and have very little experience with VBA.
I would like help on how to hover over the cell and make it highlighted like in the main body of the periodic table.
Also how do you create the large box at the top which populates with various information from the data tab?
Finally how to create either drop down menus/filter selection that can be clicked to highlight all the cells with the relevant information?
Does anyone have a video or step by step guide on how the periodic table was created or could point me in the direction of how I could start to learn how to try and create something similar. I know it is quite a complicated task for someone who is not an experienced excel user, but if I could get the idea to work it would really help.
