Adding rows after entering data

Thornsberry

New Member
Joined
Feb 4, 2005
Messages
1
I have created a Education credit tracker for inspectors here at work but the problem i ran into is when they fill the worksheet up I have to manually go and add rows is there a way to automatically do this.

Basically I want to add a row with the formulas to the end of the sheet when there is no new row to input data.
 

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.
I'm sure there's a way to do this. More info on the layout of your workbook would be helpful, though. Can you post a representative sample of your work using Colo's HTML Maker utility so we can see what you're working with? Thanks.
 
Upvote 0

Forum statistics

Threads
1,203,468
Messages
6,055,597
Members
444,800
Latest member
KarenTheManager

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top