Rolling Average

Hi cory0789

How is the new data(no's) entered....via code, manual input, from a textbox, comboBox ?
Is the average the sum of all rows divided by the no of rows?

If so, give this a try

Please Login or Register  to view this content.

The current information is entered on line 10 and then when submitted adds a new row for line 10 and moves the data down a row.

I need it to do this from column A through BB.

I will work with your code to see if I can make it work but if you have an easier way doing it all the way across that would be great

I cannot figure out how to make variables to make it go all the way across the worksheet... need more advice on this please

Have all the columns got the same amount of lines or does each column get populated individually. A sample workbook depicting a before and after will be very helpful.

Hello cory0789,

As sintek has suggested in Post#4,

Please attach a sample workbook. we don't like to create a workbook on assumptions to get the a possible guessing solution.

Make sure there is just enough data to demonstrate your need.

Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Regards.

Here you go, this has been tested and works.

Please Login or Register  to view this content.