How To Create A Dynamic Report In Excel From Any Table In ONE CLICK + FREE DOWNLOAD

In this week's training, I am going to show you how to create this incredible report, in just ONE CLICK from any table or worksheet data.
This is not just any report, because this dynamic report includes:
- 1 Click Show & Hide Columns
- 1 Click Add Filters including Date Range with Pop-Up Date Pickers
- 1 Click Sorting Ascending or Descending 1 Click Add Total
- Drag & Drop Column Rearranging Drag To Remove Columns Edit & User Modes
and a WHOLE lot more.

⬇𝗗𝗢𝗪𝗡𝗟𝗢𝗔𝗗 𝗧𝗛𝗜𝗦 𝗪𝗘𝗘𝗞'𝗦 𝗪𝗢𝗥𝗞𝗕𝗢𝗢𝗞 𝗧𝗘𝗠𝗣𝗟𝗔𝗧𝗘 𝗛𝗘𝗥𝗘:

GET AN UPDATED TRAINING AND TEMPLATE WITH THE FOLLOWING FEATURES:
• Color Sorted Columns
• Right Click In Table
• Print Report
• Save As PDF
• Set Minimum Column Width

TIMESTAMPS:
0:00 – Introduction
0:46 – Overview
17:31 – Deactivate Workbooks
18:04 – Sheet Before Right Click
20:52 – Create Report Sheet
22:43 – App Events Stop & Start
23:22 – Create Report Sheet
38:04 – Update DB Fields
45:20 – Update Column Headers
1:05:31 – Set Up Filter
1:20:54 – Refresh Report
1:32:36 – Update Totals
1:42:02 – Sort Report
1:54:18 – Change Event Worksheet
2:00:15- Selection Change Event
2:14:48 – Open Edit Mode
2:16:50 – Close Edit Mode
2:18:12 – Select to Sort
2:24:25 – Check for Move
2:35:33 – Clear Filter
2:39:07 – Conditional Formatting

#ReportGeneration #ManagementReporting #DataAnalysis #DataVisualizatio

[benlindford]

If anybody was interested in a solution for the issue mentioned at 13:45 impacting the right-click contextual menu (that triggers when you right click on a cell that's not within a table range but doesn't when you right click on a cell within a table range...).

CommandBars("Cell") pertains to the object for the menu that triggers when you right click on a non-table intersecting cell.
CommandBars("List Range Popup") pertains to the object for the menu that triggers when you right click on a cell that does intersect a table range.

It should be simple enough to duplicate and slightly amend the code Randy has provided to add the custom control to the 'Table Cells Right Click Contextual Menu' when Randy's original code triggers.

[osamasaid]

All the lessons you provide are very useful and helpful

[dr.hamzamustafa]

Thank you for your time and I hope you successful

[mrsnicker]

Hi randy I love your tutorials it helps me a lot. Hoping someday you'll create a database for churches with all the members, income and expenses on it. Thank you very much

[alexrosen]

Amazing... from start to finish, just amazing

[slminc]

Epic - I will be testing this one with the Field Service Manager training you did in the past.

[yusufmustafa]

Perfect channel.
Very outstanding explanations.
Thank you sir

[BenLinfordUK]

Another corker on the cards here.
Intrigued to watch this one with a view to hybridise the column rearrangement technique with something I've started within the past week or two to validate and adjust column layout across multiple 'database' sources. 🌟

[continuum]

Thanks Sir one again practically 🔥 packed.

I have sales table with date column and sales amount colum.I want to create a tabular report with rows that give me (i) sub total based on the months and also (ii) grand total up to each of the months and a total grand total.
E.g
(i) June total sale row
(ii) apr - June total sales row
Above two row repeat for each month in that table .
Lastly.
(iii) grand total .

Is it possible in excel ? Been thinking it for more than months.

[rachelgetter]

Do you have any templates that could be used for controlling licences and making sure they are renewed in plenty of time before they run out?

[GadgetsWorlds]

Sir I m a big fan of yours i have created many applications in Excel by watching your videos. Thank you very much. But i have a question why my application lag so much there is too much load is it better to create in Ms Access or in C Sharp.
What is your suggestion. Thanks in Advance.

[TheBrandon]

Hey Randy, Ive added new column in the customer database, however when i generate report, the column doesnt have any colour in the reporting sheet. Do you know why?

[hearphone]

Hi sir, This is Santhosh from India, I have one doubt, Is there any possibility to create auto login and web scrapping using vba & download some pdf files

[hamzahussain]

@ExcelForFreelancers  Plz make one click create customise mindmap it would be better

[LynnVanAarde-ipgy]

Hi Randy, I have recently moved over to Office 365 and I am very frustrated with it. I cannot right click and get the create report options

[freevoicebd]

If (A2="ARTEX" or "SUFIA") and (C2="EXPORT") then (D2) will Be A2 cell value, otherwise (D2) will be B2 cell value.

How to solived this by formula? Please help.

[zainulabidin]

great videos but the workbook cannot be downloaded on Facebook messenger

[christianstone]

OK, so can you just copy and paste these commands?

[atyuinnegi]

Man, ,, you are amazing, , , just amazing, you're not excel for freelancers, , you're Mitsubishi's Lancer....😉😉😉

[amosagyei]

Your templates does not work on my laptops. The VGAs do not run the codes. I keep getting error