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
@DD38 Welcome to the community! Please see attached a sample workflow to delete rows that do not have “United Kingdom” in column Z and keeps the formula in the remaining cells. It uses Read Column and Insert/Delete Rows activities.