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

What are your favorite Office Scripts that you use often or saves you the most amount of time?

I often use VBA and LAMBDA functions to speed up my work.

My favorite VBA script, which I use a lot, is one that lets me append worksheets from another workbook into my active workbook.

However, because of Excel Online and security concerns, things are shifting toward Office Scripts. Some VBA scripts I couldn't migrate (like the one above), but others worked.

For example, one I use regularly is an Office Script that consolidates the worksheets of my workbook into a single worksheet:

(I am not allowed to post this here as square brackets are forbidden)

I'm curious how many of you use Office Scripts and what you've built with them to save time.

submitted by /u/ExoWire
[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
#Excel compatibility
#Excel alternatives
#rows.com
#real-time data collaboration
#real-time collaboration
#natural language processing for spreadsheets
#generative AI for data analysis
#financial modeling with spreadsheets
#Office Scripts
#VBA
#LAMBDA functions
#workbook
#worksheets
#consolidates
#Excel Online
#security concerns
#migrate
#favorite script
#append