Need to filter data in excel sheet and and remove those rows in excel sheet.
I tried with filtering data table and pasting it in same sheet. But the existing formulas in the cells are getting removed.
Requirement is when apply filter in excel sheet formulas should not be removed.
Would someone please propose some ideas on this issue.