D
Dennis
I have been trying to create a button that inserts a group
of cells between existing cells on a worksheet. I have
been able insert those cells at the end of the worksheet
but have been unable to figure out how to insert them
between exisiting cells.
To clarify; The following is a simple representation of
what I am trying to accomplish
Position 1 - Task Name and cost (multiple rows)
Position 2 - Sub Totals and markups (multiple rows)
Position 3 - End of used cells
I need to be able to add tasks between Position 1 and 2
while carrying all of the associated formulas with
Position 2. I would like to accomplish this function
through the use of a command button which would insert the
new task between position 1 and 2 when clicked.
It is possible to have dozens of tasks once the sheet is
completed but I need the ability to add those tasks on an
individual basis.
Could anyone give me some suggestions on how to accomplish
the above? I would greatly appreciate any assistance.
Thanks,
Dennis
of cells between existing cells on a worksheet. I have
been able insert those cells at the end of the worksheet
but have been unable to figure out how to insert them
between exisiting cells.
To clarify; The following is a simple representation of
what I am trying to accomplish
Position 1 - Task Name and cost (multiple rows)
Position 2 - Sub Totals and markups (multiple rows)
Position 3 - End of used cells
I need to be able to add tasks between Position 1 and 2
while carrying all of the associated formulas with
Position 2. I would like to accomplish this function
through the use of a command button which would insert the
new task between position 1 and 2 when clicked.
It is possible to have dozens of tasks once the sheet is
completed but I need the ability to add those tasks on an
individual basis.
Could anyone give me some suggestions on how to accomplish
the above? I would greatly appreciate any assistance.
Thanks,
Dennis