At the end of each week I auto compile a league table over 40 weeks of the season.
There are all on one sheet and the same columns.
Each has a Header row and 22 teams etc
Each table spans 10 columns
23 x 10
Each table needs sorting
Columns in order of sort is Points. GD F all need to be descending.
Now the hard part excel 2000 only.
Is it possible to do this?
First table
Capturex.JPG
The 1st table is in D1:M23 correct?
Where are the other tables?
Record a macro where you sort the first table with all your criteria. Then post that recorded macro code here and describe where the other tables are. Someone could modify your recorded macro to loop through the other tables.
Excel 2000 shouldn't be an issue for just a sorting macro, but it's good that you mentioned it.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
Please Login or Register to view this content.
Where are the 39 other tables located?Originally Posted by peterfc2
Please Login or Register to view this content.
row 24
All under this one
Please Login or Register to view this content.
Excellent. Well done AlphaFrog. Thanks mate.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks