Insert rows and copy forumla above it
 

I have a spread sheet that I use for my staff. I have protected all of the
cells that have formulas because they keep going in and deleting them. They
are allowed to insert rows when their client base increases. However, when
they insert a row the formula does not copy into the inserted row. They can
not copy and paste because it is protected. So at the end of each month I
have unprotect each workbook and repaste the formula into the inserted rows.
The overall numbers and tracking are off until I do this. Is there a way to
make the formula's copy when a row is inserted and not allow them to screw up
the rest of the formulas?
--
Lisa M.

Insert rows and copy forumla above it
 

David McRitchie shares some code:
http://www.mvps.org/dmcritchie/excel/insrtrow.htm
look for: InsertRowsAndFillFormulas

If you're new to macros:

Debra Dalgleish has some notes how to implement macros he
http://www.contextures.com/xlvba01.html

David McRitchie has an intro to macros:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Ron de Bruin's intro to macros:
http://www.rondebruin.nl/code.htm

(General, Regular and Standard modules all describe the same thing.)

Lisa wrote:

I have a spread sheet that I use for my staff. I have protected all of the
cells that have formulas because they keep going in and deleting them. They
are allowed to insert rows when their client base increases. However, when
they insert a row the formula does not copy into the inserted row. They can
not copy and paste because it is protected. So at the end of each month I
have unprotect each workbook and repaste the formula into the inserted rows.
The overall numbers and tracking are off until I do this. Is there a way to
make the formula's copy when a row is inserted and not allow them to screw up
the rest of the formulas?
--
Lisa M.

--

Dave Peterson

Insert rows and copy forumla above it
 

I was not able to understand any of the links.
--
Lisa M.


"Dave Peterson" wrote:

David McRitchie shares some code:
http://www.mvps.org/dmcritchie/excel/insrtrow.htm
look for: InsertRowsAndFillFormulas

If you're new to macros:

Debra Dalgleish has some notes how to implement macros he
http://www.contextures.com/xlvba01.html

David McRitchie has an intro to macros:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Ron de Bruin's intro to macros:
http://www.rondebruin.nl/code.htm

(General, Regular and Standard modules all describe the same thing.)

Lisa wrote:

I have a spread sheet that I use for my staff. I have protected all of the
cells that have formulas because they keep going in and deleting them. They
are allowed to insert rows when their client base increases. However, when
they insert a row the formula does not copy into the inserted row. They can
not copy and paste because it is protected. So at the end of each month I
have unprotect each workbook and repaste the formula into the inserted rows.
The overall numbers and tracking are off until I do this. Is there a way to
make the formula's copy when a row is inserted and not allow them to screw up
the rest of the formulas?
--
Lisa M.

--

Dave Peterson

Insert rows and copy forumla above it
 

If you have a specific question, maybe someone can help.

Lisa wrote:

I was not able to understand any of the links.
--
Lisa M.

"Dave Peterson" wrote:

David McRitchie shares some code:
http://www.mvps.org/dmcritchie/excel/insrtrow.htm
look for: InsertRowsAndFillFormulas

If you're new to macros:

Debra Dalgleish has some notes how to implement macros he
http://www.contextures.com/xlvba01.html

David McRitchie has an intro to macros:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Ron de Bruin's intro to macros:
http://www.rondebruin.nl/code.htm

(General, Regular and Standard modules all describe the same thing.)

Lisa wrote:

I have a spread sheet that I use for my staff. I have protected all of the
cells that have formulas because they keep going in and deleting them. They
are allowed to insert rows when their client base increases. However, when
they insert a row the formula does not copy into the inserted row. They can
not copy and paste because it is protected. So at the end of each month I
have unprotect each workbook and repaste the formula into the inserted rows.
The overall numbers and tracking are off until I do this. Is there a way to
make the formula's copy when a row is inserted and not allow them to screw up
the rest of the formulas?
--
Lisa M.

--

Dave Peterson


--

Dave Peterson