| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Macro to repeat formulas in next row
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 |
|
#2
|
|||
|
|||
|
ToolsOptionsEdit, check Extend data range formats and formulas
Depends on your version of Excel -- Kind Regards, Niek Otten Microsoft MVP - Excel "katiekay" wrote in message ... 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 |
|
#3
|
|||
|
|||
|
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" wrote in message ... 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 |
|
#4
|
|||
|
|||
|
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: ToolsOptionsEdit, check Extend data range formats and formulas Depends on your version of Excel -- Kind Regards, Niek Otten Microsoft MVP - Excel "katiekay" wrote in message ... 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 |
|
#5
|
|||
|
|||
|
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" wrote in message ... 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 |
|
#6
|
|||
|
|||
|
After you have entered the formula you can just press ctrl + d to fill down
the formula -- Regards, Peo Sjoblom "katiekay" wrote in message ... 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" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date macro | Excel Discussion (Misc queries) | |||
| How to program an excel macro to repeat a series of keystrokes? | Excel Discussion (Misc queries) | |||
| Building a table with formulas rather than a macro | Excel Worksheet Functions | |||
| Macro and If Statement | Excel Discussion (Misc queries) | |||
| Macro for formulas | Excel Worksheet Functions | |||
Linear Mode
