Ascending Table With VBA Macro's

[TimSM]

<style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Helvetica Neue'; color: #454545}p.p2 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Helvetica Neue'; color: #454545; min-height: 14.0px}</style> am trying to create an “Ascending Table” with the newest Row added to the top instead of the bottom of the Table.


I have a button and Macro that adds a New Row at the Top of the Table. However, when I add a new ROW to the Top of the Table, all of the Formulas are added to the New Row except the first Two Columns (“B” and “C” Columns?


I don’t think my Sequential Numbering Formula is correct for a “Ascending Table” in the First Column”B”; and have not been able to find any info on the Web for this,


I have not Idea as to why the Formula in Column “C” is not being added. All of the Formulas from the other Columns in the Row are added?


Additionally, I would like to Do Away with the Button for adding a “New Row”; and have the Macro VBA add a New Row whenever Column “C” of the Row is populated with data.


Lastly, if possible, I would like two identical tables with the Table on Sheet One just showing the last Rows Entries on the table with the ability to input data in the cells; and Sheet 2 showing all of the rows of the table.


Thanks,
Tim