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