projecthelp
New Member
- Joined
- Dec 9, 2016
- Messages
- 2
Hey Guys,
At work, I have a report that is essentially just copy and pasting our volume from our SAP/BI website and pasting it into an excel sheet. I feel like this can easily be done with Excel Macros, but whenever I try to search youtube videos on how to do it, I get confused. I go to the developer tab, press record data, go to the data tab, press import from web, go to the website, import the data. After I do that, I press stop macros, however when I try to run the macros again I get the macro name of personal.xlsb in front of the macro name and it doesn't run.
Can someone please help?
Thanks
At work, I have a report that is essentially just copy and pasting our volume from our SAP/BI website and pasting it into an excel sheet. I feel like this can easily be done with Excel Macros, but whenever I try to search youtube videos on how to do it, I get confused. I go to the developer tab, press record data, go to the data tab, press import from web, go to the website, import the data. After I do that, I press stop macros, however when I try to run the macros again I get the macro name of personal.xlsb in front of the macro name and it doesn't run.
Can someone please help?
Thanks