My spreadsheet is a series of dates with related data.
Sometimes there is a date missing in the sequence. I want to add an
additional row in this case and insert zero values for the data.
I would like to do this automatically and am not sure if I can use an if
function to run a macro, ie if to find if a date is missing and if yes,
launch the macro.
Would be grateful for any thoughts on this

You would need an event macro,

http://www.mvps.org/dmcritchie/excel/event.htm

http://www.mvps.org/dmcritchie/excel/insrtrow.htm


Regards,

Peo Sjoblom


"BP" wrote:

My spreadsheet is a series of dates with related data.
Sometimes there is a date missing in the sequence. I want to add an
additional row in this case and insert zero values for the data.
I would like to do this automatically and am not sure if I can use an if
function to run a macro, ie if to find if a date is missing and if yes,
launch the macro.
Would be grateful for any thoughts on this