San Antonio Heat
Active Member
- Joined
- Oct 10, 2003
- Messages
- 333
- Office Version
- 2019
- Platform
- Windows
I have about 6, 000 teams in this xcel sheet. I would liek to try a small bit of code to take the list and run them from left to right. If ya notice Team 1 and team 2 uses 2 colums in A and B for their 20 team roster. Can I use some kind of code to make them list them from left to right, say team 1 will use line 6 only and team 2 will use only 17 only, so in 6 and 17 it will run 20 colums to the left and it will take the info from A nad B and put them in the proper spaces. Is this too hard?
Book1 | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
2 | 2003Draft | |||||
3 | ||||||
4 | League1 | |||||
5 | League1Team1 | |||||
6 | Pick1:LaDainianTomlinson | Pick2:PlaxicoBurress | ||||
7 | Pick3:AmosZereoue | Pick4:ChadJohnson | ||||
8 | Pick5:QuincyMorgan | Pick6:ChrisChambers | ||||
9 | Pick7:MoeWilliams | Pick8:AntonioBryant | ||||
10 | Pick9:KerryCollins | Pick10:BubbaFranks | ||||
11 | Pick11:MarcBulger | Pick12:JonKitna | ||||
12 | Pick13:LaBrandonToefield | Pick14:Pittsburgh | ||||
13 | Pick15:BobbyShaw | Pick16:JoshReed | ||||
14 | Pick17:JerramyStevens | Pick18:JustinMcCareins | ||||
15 | Pick19:WillisMcGahee | Pick20:AaronElling | ||||
16 | League1Team2 | |||||
17 | Pick1:ClintonPortis | Pick2:EddieGeorge | ||||
18 | Pick3:AmaniToomer | Pick4:OlandisGary | ||||
19 | Pick5:DerrickMason | Pick6:MattHasselbeck | ||||
20 | Pick7:AshleyLelie | Pick8:WesleyWalls | ||||
21 | Pick9:Carolina | Pick10:CoreyBradford | ||||
22 | Pick11:LarryJohnson | Pick12:DennisNorthcutt | ||||
23 | Pick13:BillSchroeder | Pick14:DougJolley | ||||
24 | Pick15:JoeyHarrington | Pick16:JohnCarney | ||||
25 | Pick17:ShaunMcDonald | Pick18:MichaelBennett | ||||
26 | Pick19:QuentinGriffin | Pick20:FreddieMitchell | ||||
Sheet1 |