on 03-26-2018 7:03 AM
Hi,
I'm newer to VBA. I need to do a mass change of about 3000 sales orders. Therefore I would like to have a macro that copies 3 different columns from excel into sap
Sales order # - Data 1 - Data 2
Copy sales order from excel - do transaction /nva02 - paste
copy Data 1 in excel - paste in Sap
copy Data 2 in excel - paste in Sap
And if possible to have an additional column to confirm if order is updated (ok)
Next sales order etc until last row
The excel sheet will be used by multiple people users Something like Active workbook would be more helpful than a path
I am aware that there are similar threats but more the other way around
Could you please help providing a VBA code I know how to do Script recording
Thanks a lot in advance
Alex
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.