I'm trying to simplify a template that I've been working on for some time. Thanks to the assistance provided on this site, I've been able to put together a decent amount of formulas for analyzing my data. However, over time my data set has increased exponentially and my process for updating has become tedious. I've attached a sample template which includes a "Main" sheet which includes all of the formulas as well as a set of dates (Rows: AN-AY) that is being used in a portion of the formulas.
I've received a number of replies indicating that I should use a single sheet for all of the data and run my analysis from here. As I am very unfamiliar with creating and using pivot tables, I'm looking for assistance on how I would go about setting one up. My presumption is that I would need to combine my individual sheets into a single sheet which I have done on "Sheet4". Another area in which I need assistance is how to reconfigure my formulas to work off a single sheet rather than individual. In my initial formulas for Pick Date, Last 10, Last 20, Pick League, Pick Game, Pick Outcome and Pick Line were pretty simplistic as they just pulled from the particular cells corresponding to the indirect reference of the sheet name (Member Link). Where I am lost is how I would get this information once all of the sheets are combined into a single sheet. The hardest part for me currently is the updating of each of the sheets (which number in the 500+) with the latest data. I had tried using a Macro but all of my attempts failed due to the data being updated would simply paste over the existing data which would render my analysis invalid since I needed the historical data. Which brings me back to my reason for being here. If I can use a single sheet for my raw data, this would be a game changer.
Thank you in advance for any and all assistance.....Go
Bookmarks