Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy paste formula to skip rows | Excel Worksheet Functions | |||
How do I copy a formula with relative ref. keeping the same ref.? | Excel Discussion (Misc queries) | |||
Insert Formula and Copy to other cells | Excel Discussion (Misc queries) | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Insert rows, keep a formula? | Excel Worksheet Functions |