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

Help Automation Ops
,
1

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

2

Hi @anjani_priya

Can you share the input file.

Regards

3

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

4

Can you send the required output too @anjani_priya

Regards

1 Like
5

sheet1.xlsx (15.5 KB)
in output sheet

1 Like
6

Give me some time @anjani_priya

I will get back to you.

Regards

1 Like
7

can you help mw with the Solution

8

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!!

9

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

10

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

11

Capture27
Capture27747×68 3.97 KB

false

12

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

13

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