Hello,
I'm new to the forum and I'm writing to you because I haven't managed to find an answer in the various posts. I started learning and using macros some time ago in order to automate / save time in my work but I must admit that I have very little knowledge in the field ...
I'm using SBO SAP Analysis to insert data into an Excel file and I've started using Macros to fill in fields from Excel cell values. This works, but I can't figure out how to adapt my code in the case where I need to fill in 2 values for the same variable. In the example below, I want to retrieve data for April 2023 and April 2024. My macro works and carries over the first value "04.2023" but I can't figure out how to insert the second value "04.2024". I hope the image will help illustrate the problem.
If I'm not mistaken, the question was asked on this forum a few years ago but I don't understand the answer either
VBA code to select multiple variables in SAP AfO
I'm new to the forum and I'm writing to you because I haven't managed to find an answer in the various posts. I started learning and using macros some time ago in order to automate / save time in my work but I must admit that I have very little knowledge in the field ...
I'm using SBO SAP Analysis to insert data into an Excel file and I've started using Macros to fill in fields from Excel cell values. This works, but I can't figure out how to adapt my code in the case where I need to fill in 2 values for the same variable. In the example below, I want to retrieve data for April 2023 and April 2024. My macro works and carries over the first value "04.2023" but I can't figure out how to insert the second value "04.2024". I hope the image will help illustrate the problem.
If I'm not mistaken, the question was asked on this forum a few years ago but I don't understand the answer either
VBA code to select multiple variables in SAP AfO