Copy if

[SPLUCENA]

Hi,

I want to copy the rows that meet my criteria in conditional formatting into a new sheet. How can i do this in excel?

Example:

From range A:G all rows that meet the "write off" criteria will be selected (including the datas) and paste it to a new sheet with the format.


Thanks for the usual assistance.


Thanks,

splucena