Hello
Neogeek here
I have a problem I have been trying to solve for days with no luck.

I am creating an Expense Workbook for myself and a few friends of mine that are employed in the same type of industry (Heavy Construction), that can help us deal with some of the idiotic tax laws that we have to deal with.

Specs:
OS= WinXP
Excel = 97 to 2k3

Workbook:
10 sheets, protected and customized

(Attaached is a .doc with an Image of one of the sheets to give you a view of what the pages look like)

Each sheet is for different data entries concerning types of tax codes.
At the bottom of each sheet is the totals dealing with sub totals, sales tax, receipt types and value types.

Previous rows are for the data entry.

Here is what I am trying to do;
  • When data entry reaches the last row in the data entry range I want a macro to fire and “insert row” and copy “each cells format, data validation and formulas.
  • Update the formulas in the cells below (“At the bottom of each sheet is the totals dealing with sub totals, sales tax, receipt types and value types.”)
I have tried to record a macro to accomplish this function and it only inserts the row, copies the format but does not copy the validation and formulas to the new row. It does, however update the totals range.

Does anyone have a solution for this Issue ??