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