I have a excel database of customers and I need to select the cell with the email address from every 4th row. How do I do this? I would then like it to automatically copy and paste into a new excel spreadsheet. Is this possible? Thanks
You can use this formula in a new Conditional Formatting rule to highlight every 4th row:
After that, you can filter these row by color, and copy them into another sheet.
Please find the attached file.
Hope that helps