|
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 |
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 |
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 |
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 |
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 |
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 |
| All times are GMT +1. The time now is 03:50 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com