Insert blank row to seperate weeks(autofilter on)

L

lunker55

I have a sheet that I need to put a blank grey row between every week. I
have multiple entries on multilpe days and sometimes no entries in a week.
I created a macro to insert blank rows between days, but now only want
between weeks(don't know how).
The problem is that autofilter is on. When I inserted blank rows between
days in autofilter, f there was three days between entries, three blank rows
would show.
Is there a way to do this, or am I going about this the wrong way?

Joe
 
D

Debra Dalgleish

You could use conditional formatting to highlight the rows in which a
different week starts. For example:

Select cells A2:G50
Choose Format>Conditional Formatting
From the first dropdown, choose Formula Is
In the formula box, type:
=INT($A2/7)<>INT($A1/7)
Click the Format button
Choose a border and/or pattern to highlight the row
Click OK, click OK
 
L

lunker55

Thanks Debra,
Not working exactly the way I need it to,but thanks anyways.

Joe
 
Top