•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Macros to Automate or Other Option
Our take
If you find yourself repeatedly copying and pasting data into Excel each month, it’s time to explore automation options that can streamline your workflow. While macros are a common solution, they may not always meet your needs. Recent advancements in AI-native spreadsheet technology offer innovative alternatives that can simplify tasks like reformatting, filtering, and formula application. By leveraging these new tools, you can reduce manual effort and enhance productivity, allowing you to focus on more strategic aspects of your work.
Question here. Every month I'm copying pasting from one system into excel. Reformat, filter, add formulas, paste into GP.
Rinse and Repeat
I have been meaning to automate it so I dont have to do same formulas and formatting each month on each tab. I know how to record macros but I wasnt ever that successful doing with others. With all the advances lately is there other options besides that?
Copy paste out is best option for export for now and so is paste into GP. That part is fast enough I dont care.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Excel automation , copy and paste formulas on going each month?How do I automate excel? Every month I have to copy the previous month tab “March 2026” then create a new tab rename it to the new month “April 2026” move the formula to use the Mar and April data instead of Feb and March? How to use it ongoing so it does it every new month April to May, May to June etc? Please help submitted by /u/No-Decision3003 [link] [comments]
- Doing the same steps over and over to an excel doc downloaded from salesforce - how to simplify?hi, i download an excel file from salesforce multiple times per day and do the same formatting/functions with it over and over. i know that there must be an easier way than doing this manually. i basically download the excel file from salesforce, do some formatting (make the rows all the same height, format numbers to be $0.00, filter by a column to remove zeros, then subtotal by a specific column). how can i do this quicker. macro? submitted by /u/beancounter_00 [link] [comments]
- Quality of Life Macros Ideas - AccountingI 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]
- Need macro advice! Saving longer numbers as strings to show all the charactersDesktop, Excel 365 Build 19929.20106 Click-to-Run, Beginner We have a macro that generates new files using a list of data. Sometimes that data is completely numerical with over 15 digits. Excel keeps reformatting these numerical entries using scientific notation, which screws up the output files. Right now I have to manually check the output files and reformat the affected ones so that all then hidden characters are shown. Can someone please advise on how I can update the macro to automatically convert these numbers into strings that show all the characters? The data is of variable length, but I'm pretty sure it's always under 20 characters. This problem only affects one cell of the output file. Everything else is generated without issue. It's basically the problem of "how do I make Excel macro copy-paste the entire FedEx tracking number correctly" but the data isn't consistently 16 characters and is frequently alphanumeric. EDIT: I'm open to even stupid and booleg solutions like "add a hidden text character before transferring the data" to force this to work. The output files are basically just printables. I just don't know anything about macros and do not have time to learn. submitted by /u/Umklopp [link] [comments]
Tagged with
#Excel alternatives for data analysis#natural language processing for spreadsheets#generative AI for data analysis#Excel compatibility#financial modeling with spreadsheets#Excel alternatives#rows.com#Excel#automation#macros#formulas#task automation#copy paste#reformat#spreadsheet#filter#recording macros#GP#reuse#export