ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Insert Row & Copy Formula (https://www.excelbanter.com/excel-worksheet-functions/79696-insert-row-copy-formula.html)

redruthann

Insert Row & Copy Formula
 
Hello,


I am hoping that someone could provide me with a script that will insert 1
row below the last data row copying that last data row to create a new data
entry row (keeping formulas constant (not absolute though)...I have done some
research, but i can not decifer what is actually the formula or
instructions/notes.
Here is my data:

Range: B4-K17 - which row 17 is the totals row.

I would like to assign a button to insert a new data input row below row
'16' (not absolute) - and any time thereafter.

Is it possible for someone to help me with this using the exact script? I
would VERY much appreciate anyone's help.

Ruthann




All times are GMT +1. The time now is 07:14 AM.

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