How_Do_I
Well-known Member
- Joined
- Oct 23, 2009
- Messages
- 1,831
- Office Version
- 2010
- Platform
- Windows
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?
<?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?