View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dtown Dawg Dtown Dawg is offline
external usenet poster
 
Posts: 22
Default Insert A blank Row Everytime the date changes in column B

I have an xls sheet with 500 rows and 4 columns. In column B is the date for
that particular record.
Is there a way that I can have xls insert a blank row everytime it
encounters a change in date in colum B. For example I may have 10 records
with the date 01-Sep-06, then after those 10 records that date wil be
02-Sep-06 and that may be 5 rows.
I want a blank row automatically inserted after each change in date.