ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Macro auto inserting rows and formulas (https://www.excelbanter.com/excel-discussion-misc-queries/210255-macro-auto-inserting-rows-formulas.html)

jjoverfield

Macro auto inserting rows and formulas
 
I am trying to create a macro that will automatically insert rows based on a
change in a specific column. I also need it to insert formulas into the
inserted rows. The formulas are basic they are just =(the cell above) except
for 3 columns where it needs to be =(the cell up and to the right).



All times are GMT +1. The time now is 08:37 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com