dave470

Junior Member

Posts: 1

moving average updated in a second sheet?

So i have data on sheet one that I enter in daily in one column. I calculate the moving average in the column next to the data with something like =AVERAGE($G$2:G42)...and each day that i enter in new data, i drag the average formula down so it updates. Now, I have a second sheet. How can I have the moving average from sheet one update automatically in sheet two in ONE cell?
Is this even possible?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Moving Average	Elton Law[_2_]	Excel Worksheet Functions	8	October 27th 09 07:15 AM
Moving average	billregal	Excel Worksheet Functions	1	January 23rd 09 01:39 AM
how to do a 50 day and 200 day moving average	giovanni	Excel Discussion (Misc queries)	2	November 10th 05 02:10 PM
Moving average	Hunterbo	Charts and Charting in Excel	0	August 3rd 05 09:13 PM
Moving average	Mike B	Excel Worksheet Functions	8	March 21st 05 04:41 PM

All times are GMT +1. The time now is 01:59 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us