Auto Populate Running Average onto Second Sheet.

itsMelly

itsMelly

New Member
Joined
Jun 20, 2024
Messages
4
Office Version
  1. 365
Platform
  1. Windows
I am looking to have the running average from the first sheet auto populate into the newest available cells in a column on the second sheet.

I’d like to have each cell retain the average it used for the calculation in it’s respective row, and auto populate the cell below it with the newest running average.
IMG_1118.png
IMG_1119.png
 

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.
You must log in or register to reply here.

Similar threads

B
  • Question Question
Auto Fill values in cells with items in Data Validation or a List/range
Replies
2
Views
342
Skyybot
Skyybot
S
  • Question Question
Look up todays date and special copy paste value for multiple sheets
Replies
4
Views
228
OaklandJim
O
J
  • Solved
VBA to do certain tasks on file opening
Replies
6
Views
163
jdhfch
J
T
  • Solved
Move cursor to a specific cell after data has been entered
Replies
4
Views
405
Peter_SSs
Peter_SSs
K
  • Solved
How can I show an error message through data validation when the cell is auto populated
Replies
7
Views
391
Micron
M

Forum statistics

Threads
1,224,823
Messages
6,181,171
Members
453,021
Latest member
Justyna P

Share this page

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