2 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Quality of Life Macros Ideas - Accounting

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]

Want to read more?

Check out the full article on the original site

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