I was going to post this in Steve-O's thread but I didn't want to hijack it
Say I have a spreasheet with 10 seperate pages for hitters and pitchers, for a total of 20. Of course none of them have the same names on each of them. Is there a way without going through each sheet individually and deleting the names you don't need to sort them on a final page to average them out?
For example some sheets start with Andy Abad, where I only care about Bobby Abreu first. So on my 11th sheet I want Bobby Abreu's avearge from the previous 10, then Garrett Atkins', and moving on down the list. I know I can go from page to page and copy the sheet and cell data into an average formula, but is there a way to do it without manually doing the formula for about 475 guys?
I've been deleteing all the names off the sheets I don't want so I could do one formula and just copy and paste. But it's really time consuming deleting names I don't want, adding names on some sheets that are missing them. I'm sure there has to be a simpler way.