How do I keep a range automatically populated with a formula?

Hi,

Is there a way to have vba automatically keep a formula next of a dynamic column of cells?

I have a database on a spreadsheet where the record number always changes and the date field column needs to be modified before I throw the whole thing into a pivot table. So, I created another date column adjacent to the database called "DateEOMONTH" where I have the EOMONTH function. What I need to do is figure out a a way to have that EOMONTH function (formatted as "mmm-yyy") added to or deleted from rows as the database increases or decreases in size.

The column header cell for the Date field is named "DateStart", the DateEOMONTH header cell is named "DateEOMONTHStart", and the sheet where the database is located is Sheet11.

Is there a cool vba way to do this or is this some kind of elaborate copy/paste solution?

Thanks,

Lawrence

I'm using 2003.

Checked out the link...thanks!

The List feature works great as the database grows, but if the database contracts (fewer rows), the DateEOMONTH column remains unchanged. The EOMONTH formulas after the last record still exist, they just reference blank cells where the deata extended before the database shrank. That's a problem because the pivot table will think therer are more records than there actually are.

How do I get rid of those extra EOMONTH rows?

Lawrence