Hi I recently have been taking a deeper dive into Excel and I was thinking about how to automate a task that I have to do every month. Every month I update financial projections by manually entering in monthly expenses into a spreadsheet for each account.
I would like to find a way to pull data that I normally manually enter from SAP Netweaver and our inhouse website that lists salary charges to an Excel spreadsheet.
What do I need to learn to automate this repetitive task? I am not an expert in Computer Science by any means so if anyone has any suggestions on ways to solve this problem, topics to learn that would be helpful and/or online resources that would help me learn how to automate this data entry it would be greatly appreciated.
TL;DR I want to upload data from SAP to an Excel file where financial projections are kept so I don't have to manually enter the data in every month.
If you want to write some vba code to login into SAP and select necessary data, you need to develop custom function module on ABAP that will select it.
So it's much easier to write custom report with export to Excel. ABAP isn't very difficult to learn.