Home

Create a report using button in Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-481113%22%20slang%3D%22en-US%22%3ECreate%20a%20report%20using%20button%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-481113%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20All%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20checked%20around%20the%20forum%20to%20see%20if%20there%20was%20any%20help%20for%20what%20i%20am%20after%2C%20I%20am%20new%20to%20using%20Excel%20(only%20use%20to%20installing%20it)%20and%20i%20am%20trying%20to%20setup%20a%20report%20via%20a%20button.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20i%20would%20like%20to%20do%20is%20have%20a%20button%20that%20when%20pressed%20will%20report%20on%20lines%20that%20have%20cells%20empty%20in%20a%20column.%20Basically%20i%20have%20a%20spreadsheet%20for%20logging%20work%20coming%20in%2C%20each%20piece%20of%20work%20needs%20to%20have%20a%20reply%20within%2021%20days.%20I%20would%20like%20a%20button%20that%20when%20pressed%20will%20report%20which%20work%20is%20outstanding%20(so%20no%20out%20date).%20Is%20there%20somewhere%20i%20could%20look%20that%20will%20help%20me%20set%20this%20up%20or%20any%20advice%20you%20could%20give%20me.%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20started%20a%20new%20role%20and%20the%20spreadsheet%20used%20is%20in%20a%20bad%20way%20and%20i%20have%20so%20many%20ideas%20for%20it%20but%20its%20just%20making%20them%20happen.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20be%20most%20grateful%20for%20any%20help%20possible.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-481113%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-486279%22%20slang%3D%22en-US%22%3ERe%3A%20Create%20a%20report%20using%20button%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-486279%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F325511%22%20target%3D%22_blank%22%3E%40Stuart1985%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%2C%20there!%20I%20can%20think%20of%20a%20few%20different%20ways%20to%20help%20you%20with%20this.%3C%2FP%3E%3CP%3EOne%20of%20the%20easiest%20ones%20could%20be%20to%20create%20a%20table%20with%20your%20data%20and%20then%20add%20a%20slicer%20to%20the%20table.%3C%2FP%3E%3CP%3ECheck%20this%20video%3A%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3Dv4taBhc9ENQ%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3Dv4taBhc9ENQ%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-507427%22%20slang%3D%22en-US%22%3ERe%3A%20Create%20a%20report%20using%20button%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-507427%22%20slang%3D%22en-US%22%3E%3CP%3Ethank%20you%20for%20your%20time%20to%20reply%20i%20will%20take%20a%20look%20at%20the%20video%20and%20let%20you%20know%20how%20i%20got%20on.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-507536%22%20slang%3D%22en-US%22%3ERe%3A%20Create%20a%20report%20using%20button%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-507536%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F325511%22%20target%3D%22_blank%22%3E%40Stuart1985%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYes%2C%20please.%20Let%20me%20know%20if%20you%20need%20further%20assistance.%20Good%20luck!%3C%2FP%3E%3C%2FLINGO-BODY%3E
Stuart1985
New 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

 

 

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 ...

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!