Hi Bombea, I meant for the Quick Access Toolbar on the top of the Excel window where you have the option for New Document, Save, Save As... rnThe butt...
The whole point is to update automatically. This is a file that is downloaded from a system and if you change a caregivers name, have a new one or cha...
Hello, I want to ask you, what happens when another names of the caregivers are there? How would that work? Because the caregivers will be diffe...
Hello, My intention is to create pivot table so I can sum up the data for every caregiver. There should be 2 options from the pivot tables. 1...
Hi Velouria, Thank you very much. This was very simple, yet effective solution. Now it works! Thank you again. Best Regards...
Hello Velouria, I tried with normal module and the formula works. But when I implement the formula in the shape that I want to change the colo...
Hello to both, I don't know what the problem is, but I just can't get it to work.. @Lionel - I tried exactly the same way as yours, but when I ...
Hello Lionel, Attached you can find my dashboard with modified data. The main sheet is "Dashboard" and as you will see, all the data in the sha...
Hello Lionel, I can't get to make it work. I renamed the cells in my original file just like yours, C_1, and the shapes in the sheet "Dashboard" jus...
Hi, First of all, thank you Lionel. Second, I am sorry that I didn't provide all the facts about it. So, here they are: I am making a dashb...
Thank you! And what if I have 20 shapes in the same sheet? How can I continue the code?