Showing results for 
Search instead for 
Did you mean: 

Macro for data extracting

0 Kudos

Hello , I am trying yo make macro (vba ) in excel to extract “Contract numbers. “ related to “ Sales ordere”

For that I use (multiple select ) by copy and past

So is there any way to declare a Range for the items and use that in the script??

Former Member
0 Kudos

Thank you for visiting SAP Community to get answers to your questions. Since you're asking a question here for the first time, I recommend that you familiarize yourself with:, as it provides tips for preparing questions that draw responses from our members.

For example, you can:

- outline what steps you took to find answers (and why they weren't helpful)

- share screenshots of what you've seen/done

- make sure you've applied the appropriate tags

- use a more descriptive subject line

The more details you provide, the more likely it is that members will be able to respond. Feel free to also take our Q&A tutorial at:

Should you wish, you can revise your question by selecting Actions, then Edit.

By adding a picture to your profile you encourage readers to respond:

Accepted Solutions (0)

Answers (1)

Answers (1)

0 Kudos

Hi Moath!

Thanks for posting your question. I'm not sure I fully understand the question, or what you're trying to achieve.

Does your question relate to requiring help with Microsoft Excel, or the Emarsys Scripting Language?

Could you provide some more information, perhaps some examples, of what you are trying to achieve exactly? With more information hopefully we'll be able to provide a better answer.


Kind regards,

Maarten Dreyer

0 Kudos

Hi ,

I have file in excel. Contain a column of Contracts numbers .

Each time these numbers be different.

I extract data from SAP The Sales order matches these contract numbers.

I do that by copy make multiple select , past then export .

I want to make a macro to come directly for this file read what ever contracts number exist in the column and extract the SO matches them .

Sorry I am still beginner so maybe my words are not clear .