Hi. I have excel table that has multiple rows and columns. And I would like to keep rows which has “United Kingdon” in column Z and remove all other rows. And then I would like to overrite changes, save and close workbook.
Please see attached file. I used different scenarios as “filter data row” and “remove data row” and “invoke method”, however when I use these activities I lost formulas (getting from next page) in column AA, column AB, etc.
How can I do:
1- keep rows which has “United Kingdon” in column Z, and delete remaining rows
2- Overrite changes in the excel by keeping formulas
3-Save & close same excel file
RemoveRows.zip (541.0 KB)