How_Do_I
Well-known Member
- Joined
- Oct 23, 2009
- Messages
- 1,831
- Office Version
- 2010
- Platform
- Windows
Hi all,
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
I’m an xl novice and just wanted advance on how to progress my workbook… It’s a workbook with a sorting theme 24 teams playing each other throughout a season…
<o> </o>
My data goes into 7 columns and xl works out the basic details which I require… brilliant.
<o> </o>
Now I need to create a worksheet for each team (home and away matches) or at least an area of a worksheet per team… Those matches will have calculations performed on them and then I need to split all games in to home and away games and possibly do further calculations…
<o> </o>
How would you achieve this please… I thought advanced filters but how many would be needed for that… about 80 on my reckoning… The other factor which may swing this is, we’re only talking 12 – 24 records results going in per week.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
I’m an xl novice and just wanted advance on how to progress my workbook… It’s a workbook with a sorting theme 24 teams playing each other throughout a season…
<o> </o>
My data goes into 7 columns and xl works out the basic details which I require… brilliant.
<o> </o>
Now I need to create a worksheet for each team (home and away matches) or at least an area of a worksheet per team… Those matches will have calculations performed on them and then I need to split all games in to home and away games and possibly do further calculations…
<o> </o>
How would you achieve this please… I thought advanced filters but how many would be needed for that… about 80 on my reckoning… The other factor which may swing this is, we’re only talking 12 – 24 records results going in per week.