Create a report using button in Excel

Copper Contributor

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.

 

3 Replies

@Stuart1985 

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

 

 

thank you for your time to reply i will take a look at the video and let you know how i got on.

@Stuart1985 

Yes, please. Let me know if you need further assistance. Good luck!