hi, i am looking to write a formula or macro that will look through column a for date values. For example if cell a2 has 05/05/10 and cell a3 is blank then cell a3 should look at last active cell, which would be a2 for any other calculations.
If somebody could please help. Thanks in advance.
Bookmarks