Workbook ideas...

[How_Do_I]

Hello,
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
My question is, how would you go about making a worksheet for football current form?
<o> </o>
I’ve just used the macro which creates a worksheet for each team and transfers the data to each sheet … My data is 8 columns wide and I copied and pasted it to create 65119 rows… I was shocked at how quickly that data was sorted.
<o> </o>
Any way, the only idea I’ve had on current form involves 48 Advanced Filters run by macros initiated by comboboxes. 4 Advanced Filters would run for every result I enter, which could be quick judging by the above macro I’ve just described.
<o> </o>
The Advanced Filter is sorted by date order so where the 5<SUP>th</SUP> and 8<SUP>th</SUP> oldest results will sit… there waits my old buddy, the fabled VLOOKUP and surrounding formulas. These will take the data to a table and sort it by rank etc…
<o> </o>
So, how would you deal with current form please?

 

[lionpants]

I don't know about any of the other helpers, but I have no idea what you're talking about.

Could you please elaborate?
What is a "current form"?
Are you really using all 65 thousand rows?

 

[How_Do_I]

Current form... in this instance is sporting terminology for how a team has performed in the last nth games.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
No to the rows, I wanted to see how quick that macro was and it was quick... I'm not going to use it in my work book I just wanted to see it perform... Its current form is impressive.<o></o>

 

[lionpants]

OK...

You still have not described what you are actually in need of.
What are the 48 filters for?
What are the "results" you're talking about?

Not all of us play football or even have any knowledge of how a season plays out.

This is the Mr.Excel form after all...