•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Macros to Automate or Other Option
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]
Want to read more?
Check out the full article on the original site
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