In the attached file you could see what I have as raw data and in the other sheet the result as i Need it. (There is not need to higlight the inserted rows)
Basically I have some data which in column "A" are dates (dd/mm/yyyy).
The other columns are names and numbers.
What I need is a macro that detects when the dates (between rows) in column "A" are not consecutive and insert a row for each missing day...
If "A4" is 03/02/2012 and "A5" is 05/02/2012 then I need to insert a row between both rows and in column "A" there must show the missing Date and in column "C" there should say: NO SALE.
If the difference between rows are more than one single day then I need to insert a row for each missing day.
Could you help me please ?
Thank you in advance for your time.