Macro to repeat formulas in next row

K

katiekay

Hello
Can I write a macro to have a formula automatically repeat in each row? What
I currently do is copy the formulas to the next several rows or use the fill
handle & drag down several rows. I'd like to have it happen automatically as
I finish each row. Possible?
Thank you
 
N

Niek Otten

Tools>Options>Edit, check Extend data range formats and formulas
Depends on your version of Excel

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
K

katiekay

I checked out your suggestion, and that box was already checked. However, my
formulas still don't carry to the next line.
 
K

katiekay

Thank you. I followed your links. Unfortunately, I'm not well versed in this
sort of thing and ended up more confused. I will, however, continue to search
that website to see if I can find help with macros and/or VBA.
 
P

Peo Sjoblom

After you have entered the formula you can just press ctrl + d to fill down
the formula
 
Top