←Back to Beyond Market Intelligence
•2 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Quality of Life Macros Ideas - Accounting

Our take

Are you looking to enhance your accounting workflow with quality of life macros? Exploring effective automation solutions can significantly streamline your daily tasks. A user has shared their journey creating helpful macros, such as bulk hiding and unhiding tabs, generating a table of contents for visible sheets, and listing external workbooks with linked formulas. They've even integrated a print-to-PDF button for quick access to specific financials. What quality of life macros or automations have you found invaluable in your accounting practices?

I am shamelessly looking for quality of life macros to work into a custom add in for my day to day accounting job. Items I have worked/am working on include:

a) bulk hide and unhide tabs

b) list visible sheets (returns array of all visible sheets, with index number and link to said sheet; effectively builds a TOC)

c) List External Workbooks (searches for formulas containing brackets [ & ], returns all externally linked formulas.

d) Print FS to PDF button. Not part of the add in; built into the workbooks. Some financials have in excess of 90 tabs with 5+ sets of financials in the same workbook. Having a button to print Fund A or Fund B has been helpful. Not as dynamic as I would like it but 80% solution today is better than a 100% solution never.

My question is, what quality of life Macro or other automations has made your life easier?

Edit - because I know I'm going to see it a lot - Power Query 100% is my go to tool. Sadly I don't get to use it as often as I would like. A lot of the data being ingested is "report ready" and not tabular which is frustrating.

submitted by /u/Traditional-Wash-809
[link] [comments]

Read on the original site

Open the publisher's page for the full experience

View original article →

Tagged with

#Excel alternatives for data analysis#generative AI for data analysis#natural language processing for spreadsheets#google sheets#financial modeling with spreadsheets#rows.com#big data management in spreadsheets#conversational data analysis#Excel compatibility#real-time data collaboration#intelligent data visualization#data visualization tools#enterprise data management#big data performance#Excel alternatives#data analysis tools#data cleaning solutions#quality of life macros#Power Query#custom add in