Apr 23 2019 04:08 AM - edited Apr 23 2019 04:15 AM
Hi All,
I checked around the forum to see if there was any help for what i am after, I am new to using Excel (only use to installing it) and i am trying to setup a report via a button.
What i would like to do is have a button that when pressed will report on lines that have cells empty in a column. Basically i have a spreadsheet for logging work coming in, each piece of work needs to have a reply within 21 days. I would like a button that when pressed will report which work is outstanding (so no out date). Is there somewhere i could look that will help me set this up or any advice you could give me.
I have started a new role and the spreadsheet used is in a bad way and i have so many ideas for it but its just making them happen.
I would be most grateful for any help possible.
Apr 26 2019 08:03 AM
Hi, there! I can think of a few different ways to help you with this.
One of the easiest ones could be to create a table with your data and then add a slicer to the table.
Check this video:
https://www.youtube.com/watch?v=v4taBhc9ENQ
May 01 2019 04:17 AM
thank you for your time to reply i will take a look at the video and let you know how i got on.
May 01 2019 04:54 AM
Yes, please. Let me know if you need further assistance. Good luck!