Did you try using DataForm? With it, formulas will be entered
automatically.

heartbreakkid < wrote:
The thing is I have a vlookup formula in the third column using the the
name of the person..... is there someway i can put the formula so when
i enter the data, the formula is entered in the 3rd column?

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html