•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Any way of mass data dumps in excel? Or Automation?
I am pulling general ledger data for my company for an IRS audit and our sales company has almost 500k lines of entries each day and I’ve pulled all of that out of sap but the problem is. I had to pull two separate reports for each and now I need to combine them.
I’ve done it for the smaller companies and just compiling and sorting with a query takes an hour each. Have no other idea how to get it quicker. Looking for any tips
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#generative AI for data analysis
#natural language processing for spreadsheets
#big data management in spreadsheets
#conversational data analysis
#Excel compatibility
#rows.com
#real-time data collaboration
#intelligent data visualization
#data visualization tools
#enterprise data management
#big data performance
#Excel alternatives
#data analysis tools
#data cleaning solutions
#financial modeling with spreadsheets
#automation in spreadsheet workflows
#generative AI automation
#workflow automation
#cognitive automation