•1 min read•from 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?
Our take
In the evolving landscape of spreadsheet technology, Office Scripts are gaining traction as a powerful alternative to traditional VBA. While I often rely on VBA for tasks like appending worksheets from other workbooks, security concerns with Excel Online have prompted a shift toward Office Scripts. One script I frequently use consolidates all worksheets into a single view, enhancing efficiency. I'm interested to hear how others are leveraging Office Scripts to streamline their workflows.
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.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
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