How to replace some values with other in multiple sheets at a time

how to replace some values with other in multiple sheets at a time
like 1 as april 2 as may 3 as june so on

Hi @anjani_priya

Can you share the input file.

Regards

sheet1.xlsx (14.0 KB)
in 4 sheets i have to change period as april may june
1 - april 2 may like that upto mar

Can you send the required output too @anjani_priya

Regards

sheet1.xlsx (15.5 KB)
in output sheet

Give me some time @anjani_priya

I will get back to you.

Regards

can you help mw with the Solution

Hi @anjani_priya

Sorry for the delay. Check out the below zip file.

BlankProcess29.zip (178.6 KB)
Input:
sheet1.xlsx

Output:
sheet1 (1).xlsx

Please mention the same excel path in Write Range Workbook it will work for you.
Please change the excel file path in first Invoke code too.
Hope it helps!!

I have other sheets also i have to take only specified sheets in that
how to keep that in if

Hi @anjani_priya

Inside For each loop give the condition in If

CurrentSheet.Equals("Sheet1") Or CurrentSheet.Equals("Sheet2") Or CurrentSheet.Equals("Sheet3")

and drag the activities to the Then section.

Regards


false

getting false if i use that .can you please check with that

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.