Excel vb script

Help Activities
1

I have a excel file I need to data validation and send to someone
While they are entering success in column C
Then column D and E value should auto populated with column A and B value

2
  1. Add a “For Each Row” activity to loop through each row in the datatable obtained from the “Read Range” activity.
  2. Inside the “For Each Row” loop, add an “If” activity to check if the value in column C is “success.”
  3. If the condition is true (i.e., the value is “success”), use an “Assign” activity to set the values in columns D and E to the values in columns A and B, respectively.
  4. To perform the assignment, you can use the row variable from the “For Each Row” loop to access the values in each row.
3

@Demo_User

Write excel formula …in columnd D and E with if condition to check for success in C …then add fata from A and B else leave them blank

"=IF(C2=""SUCCESS"",A2,"""")"

Then use auto fill ramge to fill till bottom…similarly for B and E columns

Cheers

4

Could you please give vb script on this

5

@Demo_User

Vb would not run automatically…some trigger needs to be there…thsi works automatic

cheers

6

This one is not working manually in excel as well

7

@Demo_User

can you please show what you tried

cheers

8

Yes, it doesn’t work for me either.

9

I want the free text also be entered in the same file if it doesn’t matches the forumla should not distrub

10

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