Macro to repeat formulas in next row

[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

[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

"katiekay" <[email protected]> wrote in message
news:[email protected]...
> 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

[Ron de Bruin]

See
http://www.mvps.org/dmcritchie/excel/insrtrow.htm

Or use a DataForm
http://j-walk.com/ss/dataform/index.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl



"katiekay" <[email protected]> wrote in message news:[email protected]...
> 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

[katiekay]

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

"Niek Otten" wrote:

> Tools>Options>Edit, check Extend data range formats and formulas
> Depends on your version of Excel
>
> --
>
> Kind Regards,
>
> Niek Otten
>
> Microsoft MVP - Excel
>
> "katiekay" <[email protected]> wrote in message
> news:[email protected]...
> > 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
>
>
>

[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.

"Ron de Bruin" wrote:

> See
> http://www.mvps.org/dmcritchie/excel/insrtrow.htm
>
> Or use a DataForm
> http://j-walk.com/ss/dataform/index.htm
>
>
> --
> Regards Ron de Bruin
> http://www.rondebruin.nl
>
>
>
> "katiekay" <[email protected]> wrote in message news:[email protected]...
> > 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
>
>
>

[Peo Sjoblom]

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

--

Regards,

Peo Sjoblom


"katiekay" <[email protected]> wrote in message
news:[email protected]...
> 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.
>
> "Ron de Bruin" wrote:
>
> > See
> > http://www.mvps.org/dmcritchie/excel/insrtrow.htm
> >
> > Or use a DataForm
> > http://j-walk.com/ss/dataform/index.htm
> >
> >
> > --
> > Regards Ron de Bruin
> > http://www.rondebruin.nl
> >
> >
> >
> > "katiekay" <[email protected]> wrote in message
news:[email protected]...
> > > 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
> >
> >
> >

[raj soni]

sorry .
i start new thread ,
dint notice this thread is already solved.