Applying filter in the existing excel

Help Activities
,
1

I want to apply filter in column P, actually headers is in p2 cell, values are from P3 and select empty rows also want to check parallel A column cells if their is a value we should write P1 column value in respective p cells otherwise leave it empty.

2

@Gopi_Krishna1

You can use filter table activity to apply the filters and gice the raange so that it checks from second row…

Can you please explain the second part properly

Cheers

3

Can we able to do it vb script? Because the file has prebuilt formulas we should not distribute it

4

First we have to filter column P value are from P3 to until data is their, after filter we will get the only empty values in p column also we need to look parallel A column without empty, if it is without empty then we have to put P1 cell values in all the cells of p column meeting this condition.

5

@Gopi_Krishna1 ,

Yes you can use VB code. Use activity Activities - Execute Macro for this.

Thanks,
Ashok :slight_smile: