Moving average across most recent worksheets?

[rpm77]

I'm doing research and I'm having trouble with my lack of vba knowledge in my analysis.

Each trial I run I get a new worksheet tab of information. In my analysis, I have a table containing moving averages for the last ten trials. The values are averaged over the last ten trials, or equivalently the last ten worksheets. This is the main problem I encounter - How can I make a macro that will always adjust to average over the last 10 trials/worksheet tabs?

Some more information that may be relevant is that each tab is named by the date of the trial (mm-dd-yyyy) so the last 10 trials/tabs are also the 10 most recent dates.

Any help would be greatly appreciated.

[JBeaucaire]

Using a worksheet loop by sheet indexes:

Please Login or Register  to view this content.

If we can see your actual workbook and macros, we could suggest something more specific.