insert row into worksheet when date missing
I have an excel sheet that displays daily numbers per application.
Unfortunately if the application didn't receive calls it doesn't show
the date.
Calls
Application 1
10/30/2006 100
10/31/2006 120
11/1/2006 110
Application Summary
330
Application 2
10/30/2006 6
11/1/2006 2
Application Summary
8
I need a macro to automatically insert rows so that there are 7 days a
week instead of just the days that have calls.
Anyway to get this to work?
|