Try this:

From the Excel Main Menu:
<tools<options<edit tab....CHECK: Extend data range formats and formulas


Does that help?
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)

"Don" wrote in message ...
I have a spreadsheet created by someone else that will automatically fill in
a formula in column A when data is entered in column B of the same row. I
need to duplicate that in another spreadsheet and can't figure out how ...
any suggestions?
--
Don