I have a excel with formatted cells (cell color background) in all certain columns and rows, just mixed up.
My goals is to:
1 - make a copy this excel (no problem)
2 - in a loop →
a) filter data on e-mail address (column f)
b) delete everything which is not filtered
c) save the new excel WITH FORMATTET.
I can not use delete range activity as here i need the range which i do not have and I also cannot use a data table in between as I lose my formatting on the cells.
How can I get multiple smaller excel-files from one master-excel and keep the formatted color cells?