Part 2
You could have a worksheet_change event that when something is entered in
col A the formula is automatically copied in.

--
Don Guillett
SalesAid Software

"Dmorri254" wrote in message
...
Hello,

In (B2) I have the following formula:
=VLOOKUP(MONTH(A5),Lookup!$A$13:$B$24,2,FALSE)

This gives me the month based on a date entry in (A1). I need to say if A1
is blank then B2 should remain blank as well.

Also, is there a way to auto copy formulas down without manually pulling
them down to the next row?

Thank you