Automate

Hi community!

Is it possible to include Excel formula creation to transaction based script running? I know that it's possible to edit read data using formulas automatically, (Transform rule), but would it be possible to have the script add formulas to other cells as it works?

A simplified but thorough example:

I need to edit data based on Product Hierarchy. I create a script with MM03 that extracts that value to Excel column D. I have a separate table that has possible PH values in one column and a description of the needed edits in other column.

Now, I'd like to automatize work a bit. I'd like to have the needed action appear in column E automatically based on PH using Vlookup. So I'd create a formula to column E, something to the likes of =vlookup(Dn; table; action column number; false) and spread this to the needed column E rows.

Each time I run the script I have different amounts of materials I'll need to work with, so I have to apply the formula separately. Currently I have two options for this:

• Write this formula to the first row of E and then after running the script drag it down from there for as many rows as I need
• Write this formula to e.g. the first 200 rows of E to have it there already.

What I'd like to have:

• Whenever the script extracts PH value to cell Dn, it would also write formula =vlookup(Dn;table here,action column number; false) to cell En that is next to it.
  • This way I'd automatically have the needed formula added for the correct amount of rows.
  • This certainly wouldn't limit to using vlookup - inserting other functions like this would open many possibilities.

So my question is: Is it somehow possible to have Winshuttle write formulas to cells when running a script? I tried to achieve this but didn't find a way.

Hi community!

Is it possible to include Excel formula creation to transaction based script running? I know that it's possible to edit read data using formulas automatically, (Transform rule), but would it be possible to have the script add formulas to other cells as it works?

A simplified but thorough example:

I need to edit data based on Product Hierarchy. I create a script with MM03 that extracts that value to Excel column D. I have a separate table that has possible PH values in one column and a description of the needed edits in other column.

Now, I'd like to automatize work a bit. I'd like to have the needed action appear in column E automatically based on PH using Vlookup. So I'd create a formula to column E, something to the likes of =vlookup(Dn; table; action column number; false) and spread this to the needed column E rows.

Each time I run the script I have different amounts of materials I'll need to work with, so I have to apply the formula separately. Currently I have two options for this:

• Write this formula to the first row of E and then after running the script drag it down from there for as many rows as I need
• Write this formula to e.g. the first 200 rows of E to have it there already.

What I'd like to have:

• Whenever the script extracts PH value to cell Dn, it would also write formula =vlookup(Dn;table here,action column number; false) to cell En that is next to it.
  • This way I'd automatically have the needed formula added for the correct amount of rows.
  • This certainly wouldn't limit to using vlookup - inserting other functions like this would open many possibilities.

So my question is: Is it somehow possible to have Winshuttle write formulas to cells when running a script? I tried to achieve this but didn't find a way.

I agree with Jan Ketele.

I would also use a bit of VBA for this.

Hi community!

Is it possible to include Excel formula creation to transaction based script running? I know that it's possible to edit read data using formulas automatically, (Transform rule), but would it be possible to have the script add formulas to other cells as it works?

A simplified but thorough example:

I need to edit data based on Product Hierarchy. I create a script with MM03 that extracts that value to Excel column D. I have a separate table that has possible PH values in one column and a description of the needed edits in other column.

Now, I'd like to automatize work a bit. I'd like to have the needed action appear in column E automatically based on PH using Vlookup. So I'd create a formula to column E, something to the likes of =vlookup(Dn; table; action column number; false) and spread this to the needed column E rows.

Each time I run the script I have different amounts of materials I'll need to work with, so I have to apply the formula separately. Currently I have two options for this:

• Write this formula to the first row of E and then after running the script drag it down from there for as many rows as I need
• Write this formula to e.g. the first 200 rows of E to have it there already.

What I'd like to have:

• Whenever the script extracts PH value to cell Dn, it would also write formula =vlookup(Dn;table here,action column number; false) to cell En that is next to it.
  • This way I'd automatically have the needed formula added for the correct amount of rows.
  • This certainly wouldn't limit to using vlookup - inserting other functions like this would open many possibilities.

So my question is: Is it somehow possible to have Winshuttle write formulas to cells when running a script? I tried to achieve this but didn't find a way.