Excel scrip to replace a VBA to add a part of sheet name in rows.

[Saab95]

Hi there,

Add a perfectly working vba but now want to move to the cloud and automate thing so need to have an excel script instead but don't know how to achieve this.

To be honest I have no clue about excel script.

What I want is to add a part of the sheet name in a new column and at the end of each rows that contains a value.

Any idea ?

Thank you

 

[bassplr19]

how to reference the current sheet name in an function?

I am aware that you can reference other sheets in a function, but how do you reference the current sheet in one? IF(Current_sheet_name="user..

techcommunity.microsoft.com