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.
UPDATE: Mac users have Slicers as of Excel 2016 New in Excel 2013, a wonderful analytical tool: using Slicers with Tables to analyze and/or filter data sets. Slicers could be used with Pivot Tables and Pivot Charts, and Excel 2013 takes it a step further. EXCELLENT! #ExcelSlicers #ExcelTables ...