Need a script

[Former Member]

hI Experts

The Source will be as below

There will  be separate tab for each table in the xl sheet for material master

The first tab will be a control tab where the user will be passing the table name and the field to be updated

Tab1-Control--> Update table(drop down),update field(drop down)

Tab2-MARA--Material  (no, update field)

Tab3-MAKT--Material,language,update field

Tab4-MARC--MATNR,WERKS,UPdate field

Tab5-MBEW--MATNR,Validation Area,UPdate Field

Tab6-MUKE--MATRK,Salesorg,distcramal,division,update field

I need a script to dynamically pick values from control tab and go to the so and so table and update fields and trigger the job

Thanks

Madhu

[Former Member]

Hi Madhu, can you give an example and explain for what you are looking for.

[Former Member]

can you please explain in detail

[former_member205887]

If i am not wrong, you should try Excel Macros for your requirement. Explore it.