Hi! I have a workbook that is basically a database. On each sheet there is a
list of dates in column A. the rest of the columns have values corresponding
to that date. Now sometimes there is a date missing. If I want to add data to
that date I must insert a new row in every worksheet. Is there some way I can
use a macro to insert the row? Assume I want to insert 2007-02-03. I would
then search column A in every sheet for the date before ie 2007-02-02 and if
I could not find that I would search for 2007-02-01. Once found I would
insert a row. Is this possible? any help appreciated! thanks!