EXCEL Dashboard

Copper Contributor

EXCEL Dashboard

Hi Excel community

- I have this project I wish to implement at work, but I am kind of stock.

-  I have a database of clients who pick up medications from the facility periodically.

- I wish to build a dashboard where when I input the client's code (Personal ID), excel gives me in return all the days the client came for pickup and the services he received each of these days.

- I have tried, but only succeeded to have a single day appear on my dashboard.        

-  I’ll be glad to hear from all

6 Replies

@Abaasanji 

On which Excel version / platform you are ?

@Abaasanji 

Here is a solution that will work in all versions of Excel 2007 and later.

If all users will have Microsoft 365 (or, soon, Office 2021), the formulas can be a lot simpler.

@Hans Vogelaar 

No way, I still see users on Excel 2000 and even on Excel 97. That was nice time and we were younger. 

MS 2016
Thanks
Checking it now

@Sergei Baklan 

Yikes!