JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser .
trying to automate my Switch list for my model railroad operations.
I'm needing a little help figuring out how to keep the duplicate picks from showing up on my list. I've got the list to populate kinda the way it should, but I don't want duplicates. As I have it now I'm running the "set outs" from the top 50 of the list to the right and the "pick ups" from the bottom 50 of the list to the right. I'd rather just be able to pull from the whole list but I'm stumped. Any help would be appreciated.
Thanks, Steve.
The formula is copied across from B1 to I5 and then down.
It will be later today before I can try that... work gets in the way of life sometimes
How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney
You can upload the file to OneDrive or GoogleDrive, mark for sharing & post the link you are given to the thread.
You need to select the whole range, not a single cell.
That said did you clear all the cells from B5 down & across to col I?
You need to select the whole range, not a single cell.
That said did you clear all the cells from B5 down & across to col I?
yes, I've got everything below cleared
auto switchlist.xlsx A B C D E F G H I J K L M N O P Q R S T U 1 Date: 4/5/2024 2 SET OUTS 3 6 Train: #2541-GP50 Location: Elk 1 2 3 4 5 6 7 8 9 10 11 4 Location Rpt. Marks Number AAR Type LD/MTY Destination Notes Block ID Rpt. Marks Car No. Type Description Color Length LD/MTY Empty Return to 1 Notes 5 1 #SPILL! Elk 1 UP 65263 GB Gondola Yellow 41' Loaded Elk Track 2 6 2 Elk 2 SOUTHERN 1229 GB Gondola Silver 41' Loaded Elk Track 4 7 3 Spokane 3 SOUTHERN 1230 GB Gondola Silver 41' Empty Team Track 8 4 Spokane 4 CN 1231 GB Gondola Red 41' Trash Team Track 9 5 Spokane 5 North 1232 GB Gondola Black 48' Trash Team Track 10 6 Elk 6 CO 218892 GB Gondola Black 41' Loaded Elk Track 5 11 7 Elk 7 ELK GB1230 GB Gondola Black 41' Loaded Elk Track 5 12 8 Elk 8 ELK GB1231 GB Gondola Black 41' Empty Elk Track 5 13 9 Elk 9 ELK GB1232 GB Gondola Black 41' Empty Elk Track 5 14 10 Elk 10 ELK GB1233 GB Gondola Black 41' Empty Elk Track 5 15 11 Elk 11 ACF 5250 HT 4 Bay Hopper White 60' Loaded Coop 16 12 Elk 12 ACF 5251 HT 4 Bay Hopper White 60' Loaded Coop 17 13 Spokane 13 ATSF 301488 HT 4 Bay Hopper Brown 60' Loaded Spokane Yard 18 14 Spokane 14 ATSF 301489 HT 4 Bay Hopper Brown 60' Loaded Spokane Yard 19 15 Elk 15 PRR 262581 HT 4 Bay Hopper Brown 40' Empty Elk Track 2 20 16 Spokane 16 ELK HT1301 HT 4 Bay Hopper Black 62' Empty Team Track 21 17 Spokane 17 ELK HT1302 HT 4 Bay Hopper Black 62' Empty Team Track 22 18 Spokane 18 ELK HT1303 HT 4 Bay Hopper Black 62' Empty Team Track 23 19 Elk 19 WA 32985 LO 3 Bay Hopper Tan 45' Empty Elk Track 4 24 20 Elk 20 WA 32986 LO 3 Bay Hopper Tan 45' Empty Elk Track 4 25 21 Elk 21 B&O 837085 LO 3 Bay Hopper Gray 45' Empty Elk Track 4 26 22 Elk 22 L&N 30069 LO 3 Bay Hopper Brown 44' Empty Elk Track 4 27 23 Spokane 23 BN 521476 HT 90 Ton Hopper Black Loaded Spokane Yard 28 24 Spokane 24 BN 521477 HT 90 Ton Hopper Black Loaded Spokane Yard 29 25 Spokane 25 BN 521478 HT 90 Ton Hopper Black Loaded Spokane Yard 30 Spokane 26 BN 521479 HT 90 Ton Hopper Black Loaded Spokane Yard 31 PICK UPS Spokane 27 BN 521480 HT 90 Ton Hopper Black Loaded Spokane Yard 32 Location Rpt. Marks Number AAR Type LD/MTY Destination Notes Spokane 28 BN 521481 HT 90 Ton Hopper Black Loaded Spokane Yard 33 1 Spokane 29 BN 521482 HT 90 Ton Hopper Black Loaded Spokane Yard 34 2 Spokane 30 BN 521483 HT 90 Ton Hopper Black Loaded Spokane Yard 35 3 Spokane 31 MKT 10683 HT 90 Ton Hopper Black Loaded Spokane Yard 36 4 Spokane 32 BN 163210 HT 90 Ton Hopper Red Loaded Spokane Yard 37 5 Spokane 33 RG 17491 HT 90 Ton Hopper black Loaded Spokane Yard 38 6 Spokane 34 BN 163210 HT 90 Ton Hopper Alum. Loaded Spokane Yard 39 7 Davis 35 ELK HM 2 Bay Hopper Black Empty Lumber Mill 40 8 Davis 36 GN 176857 HM 2 Bay Hopper Gray 20' Empty Lumber Mill 41 9 Davis 37 GN 176858 HM 2 Bay Hopper White 20' Empty Lumber Mill 42 10 Elk 38 CN 114263 MWD 70 Ton Ore Car Brown 20' Loaded Deep Hole Mine 43 11 Elk 39 CN 114263 MWD 70 Ton Ore Car Brown 20' Loaded Deep Hole Mine 44 12 Elk 40 CN 114263 MWD 70 Ton Ore Car Brown 20' Loaded Deep Hole Mine 45 13 Elk 41 CN 114132 MWD 70 Ton Ore Car Brown 20' Loaded Deep Hole Mine 46 14 Elk 42 CN 114132 MWD 70 Ton Ore Car Brown 20' Loaded Deep Hole Mine 47 15 Elk 43 UP 26440 MWD 70 Ton Ore Car Silver 20' Loaded Deep Hole Mine 48 16 Elk 44 UP 26440 MWD 70 Ton Ore Car Silver 20' Loaded Deep Hole Mine 49 17 Elk 45 UP 26440 MWD 70 Ton Ore Car Silver 20' Loaded Deep Hole Mine 50 18 Elk 46 UP 26440 MWD 70 Ton Ore Car Silver 20' Loaded Deep Hole Mine 51 19 Elk 47 UP 26440 MWD 70 Ton Ore Car Silver 20' Loaded Deep Hole Mine 52 20 Elk 48 UP 26440 MWD 70 Ton Ore Car Silver 20' Loaded Deep Hole Mine 53 21 Elk 49 BN 189784 XM Boxcar Green 40' Empty Track 1 Elk Yard 54 22 Elk 50 B&O 11147 XM Boxcar Yellow 50' Empty Track 1 Elk Yard 55 23 Elk 51 LV 41003 XM Boxcar white 40' Loaded Monument Mnf 56 24 Elk 52 LV 41004 XM Boxcar white 40' Loaded Coop 57 25 Elk 53 CN 553290 XAF BoxCar Brown 60' Empty Coop 58 Elk 54 NW 47500 XM Boxcar Black 40' Empty Monument Mnf 59 Elk 55 GN 20680 XM Boxcar Green 40' Loaded "Transfer n Storage" 60 Elk 56 GN 22020 XM Boxcar 40' Loaded "Transfer n Storage" 61 Elk 57 BN 3407 XM Boxcar Green 40' Loaded Oil Depot 62 Davis 58 WP 3301 XM Boxcar Brown 40' Loaded Davis 63 Davis 59 WP 61959 XM Boxcar Brown 40' Empty Davis 64 Davis 60 GN 11877 XM Boxcar Red 40' Empty Davis 65 Davis 61 VT 1015 XM Boxcar Brown 40' Empty Davis 66 Davis 62 rprx 507 RCD Refer Boxcar Yellow 40' Loaded Stock Yard 67 Davis 63 WA 3000 RCD Refer Boxcar Yellow 40' Empty Stock Yard 68 Elk 64 SF 55360 RCD Refer Boxcar Orange 50' Loaded Track 1 Elk Yard 69 Davis 65 SF 55361 RCD Refer Boxcar Orange 50' Loaded Meat Packing 70 Davis 66 LV RCD71120 RCD Refer Boxcar white 50' Empty Meat Packing 71 Elk 67 LV RCD71121 RCD Refer Boxcar white 50' Empty Track 2 Elk Yard 72 Davis 68 ELK RCD71122 RCD Refer Boxcar white 50' Loaded Davis 73 Davis 69 ELK RCD71123 RCD Refer Boxcar white 50' Loaded Davis 74 Elk 70 ELK RCD71124 RCD Refer Boxcar white 50' Empty Track 2 Elk Yard 75 Elk 71 WSRX 238 T Tank Car Brown 40' Empty Track 1 Elk Yard 76 Elk 72 SCCX 1245 T Tank Car Orange 40' Loaded Track 1 Elk Yard 77 Elk 73 GN 1153 T Tank Car Black 40' Empty Track 1 Elk Yard 78 Elk 74 SCCX 1246 T Tank Car Orange 40' Loaded Track 1 Elk Yard 79 Elk 75 SP 97732 TA Chemical Tank Car Silver 40' Empty Track 1 Elk Yard 80 Elk 76 UC 97778 TA Chemical Tank Car white 40' Loaded Track 2 Elk Yard 81 Elk 77 ATSF 582039 SM Stock Car (Cattle) Green 40' Empty Ranch 82 Elk 78 ELK SM52148 SM Stock Car (Cattle) Brown 40' Empty Ranch 83 Elk 79 D&RGW 62135 SM Stock Car (Cattle) Green 40' Empty Ranch 84 Elk 80 ATSF 50659 SM Stock Car (Cattle) Green 40' Loaded Ranch 85 Davis 81 UP 476306 SM Stock Car (Cattle) Yellow 40' Empty Stock Yard 86 Davis 82 UP 47758 SM Stock Car (Cattle) Yellow 40' Empty Stock Yard 87 Davis 83 UP 176306 SM Stock Car (Cattle) Yellow 40' Empty Stock Yard 88 Elk 84 CNW 15040 SH Stock Car (Horse) gr/ylw 40' Empty Ranch 89 Elk 85 TTPX 80252 FB Bulk Head Flat Car Brown 55' Loaded Lumber Store Loaded with Lumber 90 Elk 86 TTPX 80316 FB Bulk Head Flat Car Brown 55' Loaded Lumber Store Loaded with Lumber 91 Spokane 87 UP 59163 FM Flat Car Yellow 70' loaded Team Track Loaded with 2 Trailers 92 Spokane 88 NH 84217 FM Flat Car Black 70' Wire rolls Spokane Yard 93 Elk 89 ELK FM63234 FM Flat Car Black 70' Logs Logging Camp Loaded with Logs 94 Elk 90 ELK FM63235 FM Flat Car Black 70' logs Logging Camp Loaded with Logs 95 Davis 91 BN 66208 FM Flat Car Green 41' Rail load Davis Loaded with Rail 96 Davis 92 GN 66209 FM Flat Car Brown 41' Rail load Davis Loaded with Rail 97 Elk 93 ELK FL1003 FL Logging Car Black 40' Logs Logging Camp 98 Elk 94 ELK FL1004 FL Logging Car Black 40' Logs Logging Camp 99 Elk 95 ELK FL1005 FL Logging Car Black 40' Logs Logging Camp
Thanks for that. The problem is rows 31 & 32, if you clear them it will work
Fluff.xlsm A B C D E F G H I J K L M N O P Q R S T U 1 Date: 05/04/2024 2 SET OUTS 3 3 Train: #N/A Location: Elk 1 2 3 4 5 6 7 8 9 10 11 4 Location Rpt. Marks Number AAR Type LD/MTY Destination Notes Block ID Rpt. Marks Car No. Type Description Color Length LD/MTY Empty Return to 1 Notes 5 1 1 Elk UP 65263 GB Loaded Elk Track 2 0 Elk 1 UP 65263 GB Gondola Yellow 41' Loaded Elk Track 2 6 2 2 Elk SOUTHERN 1229 GB Loaded Elk Track 4 0 Elk 2 SOUTHERN 1229 GB Gondola Silver 41' Loaded Elk Track 4 7 3 6 Elk CO 218892 GB Loaded Elk Track 5 0 Spokane 3 SOUTHERN 1230 GB Gondola Silver 41' Empty Team Track 8 4 7 Elk ELK GB1230 GB Loaded Elk Track 5 0 Spokane 4 CN 1231 GB Gondola Red 41' Trash Team Track 9 5 8 Elk ELK GB1231 GB Empty Elk Track 5 0 Spokane 5 North 1232 GB Gondola Black 48' Trash Team Track 10 6 9 Elk ELK GB1232 GB Empty Elk Track 5 0 Elk 6 CO 218892 GB Gondola Black 41' Loaded Elk Track 5 11 7 10 Elk ELK GB1233 GB Empty Elk Track 5 0 Elk 7 ELK GB1230 GB Gondola Black 41' Loaded Elk Track 5 12 8 11 Elk ACF 5250 HT Loaded Coop 0 Elk 8 ELK GB1231 GB Gondola Black 41' Empty Elk Track 5 13 9 12 Elk ACF 5251 HT Loaded Coop 0 Elk 9 ELK GB1232 GB Gondola Black 41' Empty Elk Track 5 14 10 15 Elk PRR 262581 HT Empty Elk Track 2 0 Elk 10 ELK GB1233 GB Gondola Black 41' Empty Elk Track 5 15 11 19 Elk WA 32985 LO Empty Elk Track 4 0 Elk 11 ACF 5250 HT 4 Bay Hopper White 60' Loaded Coop 16 12 20 Elk WA 32986 LO Empty Elk Track 4 0 Elk 12 ACF 5251 HT 4 Bay Hopper White 60' Loaded Coop 17 13 21 Elk B&O 837085 LO Empty Elk Track 4 0 Spokane 13 ATSF 301488 HT 4 Bay Hopper Brown 60' Loaded Spokane Yard 18 14 22 Elk L&N 30069 LO Empty Elk Track 4 0 Spokane 14 ATSF 301489 HT 4 Bay Hopper Brown 60' Loaded Spokane Yard 19 15 38 Elk CN 114263 MWD Loaded Deep Hole Mine 0 Elk 15 PRR 262581 HT 4 Bay Hopper Brown 40' Empty Elk Track 2 20 16 39 Elk CN 114263 MWD Loaded Deep Hole Mine 0 Spokane 16 ELK HT1301 HT 4 Bay Hopper Black 62' Empty Team Track 21 17 40 Elk CN 114263 MWD Loaded Deep Hole Mine 0 Spokane 17 ELK HT1302 HT 4 Bay Hopper Black 62' Empty Team Track 22 18 41 Elk CN 114132 MWD Loaded Deep Hole Mine 0 Spokane 18 ELK HT1303 HT 4 Bay Hopper Black 62' Empty Team Track 23 19 42 Elk CN 114132 MWD Loaded Deep Hole Mine 0 Elk 19 WA 32985 LO 3 Bay Hopper Tan 45' Empty Elk Track 4 24 20 43 Elk UP 26440 MWD Loaded Deep Hole Mine 0 Elk 20 WA 32986 LO 3 Bay Hopper Tan 45' Empty Elk Track 4 25 21 44 Elk UP 26440 MWD Loaded Deep Hole Mine 0 Elk 21 B&O 837085 LO 3 Bay Hopper Gray 45' Empty Elk Track 4 26 22 45 Elk UP 26440 MWD Loaded Deep Hole Mine 0 Elk 22 L&N 30069 LO 3 Bay Hopper Brown 44' Empty Elk Track 4 27 23 46 Elk UP 26440 MWD Loaded Deep Hole Mine 0 Spokane 23 BN 521476 HT 90 Ton Hopper Black Loaded Spokane Yard 28 24 47 Elk UP 26440 MWD Loaded Deep Hole Mine 0 Spokane 24 BN 521477 HT 90 Ton Hopper Black Loaded Spokane Yard 29 25 48 Elk UP 26440 MWD Loaded Deep Hole Mine 0 Spokane 25 BN 521478 HT 90 Ton Hopper Black Loaded Spokane Yard 30 49 Elk BN 189784 XM Empty Track 1 Elk Yard 0 Spokane 26 BN 521479 HT 90 Ton Hopper Black Loaded Spokane Yard 31 50 Elk B&O 11147 XM Empty Track 1 Elk Yard 0 Spokane 27 BN 521480 HT 90 Ton Hopper Black Loaded Spokane Yard 32 51 Elk LV 41003 XM Loaded Monument Mnf 0 Spokane 28 BN 521481 HT 90 Ton Hopper Black Loaded Spokane Yard 33 1 52 Elk LV 41004 XM Loaded Coop 0 Spokane 29 BN 521482 HT 90 Ton Hopper Black Loaded Spokane Yard 34 2 53 Elk CN 553290 XAF Empty Coop 0 Spokane 30 BN 521483 HT 90 Ton Hopper Black Loaded Spokane Yard 35 3 54 Elk NW 47500 XM Empty Monument Mnf 0 Spokane 31 MKT 10683 HT 90 Ton Hopper Black Loaded Spokane Yard 36 4 55 Elk GN 20680 XM Loaded "Transfer n Storage" 0 Spokane 32 BN 163210 HT 90 Ton Hopper Red Loaded Spokane Yard 37 5 56 Elk GN 22020 XM Loaded "Transfer n Storage" 0 Spokane 33 RG 17491 HT 90 Ton Hopper black Loaded Spokane Yard 38 6 57 Elk BN 3407 XM Loaded Oil Depot 0 Spokane 34 BN 163210 HT 90 Ton Hopper Alum. Loaded Spokane Yard 39 7 64 Elk SF 55360 RCD Loaded Track 1 Elk Yard 0 Davis 35 ELK HM 2 Bay Hopper Black Empty Lumber Mill 40 8 67 Elk LV RCD71121 RCD Empty Track 2 Elk Yard 0 Davis 36 GN 176857 HM 2 Bay Hopper Gray 20' Empty Lumber Mill 41 9 70 Elk ELK RCD71124 RCD Empty Track 2 Elk Yard 0 Davis 37 GN 176858 HM 2 Bay Hopper White 20' Empty Lumber Mill 42 10 71 Elk WSRX 238 T Empty Track 1 Elk Yard 0 Elk 38 CN 114263 MWD 70 Ton Ore Car Brown 20' Loaded Deep Hole Mine 43 11 72 Elk SCCX 1245 T Loaded Track 1 Elk Yard 0 Elk 39 CN 114263 MWD 70 Ton Ore Car Brown 20' Loaded Deep Hole Mine 44 12 73 Elk GN 1153 T Empty Track 1 Elk Yard 0 Elk 40 CN 114263 MWD 70 Ton Ore Car Brown 20' Loaded Deep Hole Mine 45 13 74 Elk SCCX 1246 T Loaded Track 1 Elk Yard 0 Elk 41 CN 114132 MWD 70 Ton Ore Car Brown 20' Loaded Deep Hole Mine 46 14 75 Elk SP 97732 TA Empty Track 1 Elk Yard 0 Elk 42 CN 114132 MWD 70 Ton Ore Car Brown 20' Loaded Deep Hole Mine 47 15 76 Elk UC 97778 TA Loaded Track 2 Elk Yard 0 Elk 43 UP 26440 MWD 70 Ton Ore Car Silver 20' Loaded Deep Hole Mine 48 16 77 Elk ATSF 582039 SM Empty Ranch 0 Elk 44 UP 26440 MWD 70 Ton Ore Car Silver 20' Loaded Deep Hole Mine 49 17 78 Elk ELK SM52148 SM Empty Ranch 0 Elk 45 UP 26440 MWD 70 Ton Ore Car Silver 20' Loaded Deep Hole Mine 50 18 79 Elk D&RGW 62135 SM Empty Ranch 0 Elk 46 UP 26440 MWD 70 Ton Ore Car Silver 20' Loaded Deep Hole Mine 51 19 80 Elk ATSF 50659 SM Loaded Ranch 0 Elk 47 UP 26440 MWD 70 Ton Ore Car Silver 20' Loaded Deep Hole Mine 52 20 84 Elk CNW 15040 SH Empty Ranch 0 Elk 48 UP 26440 MWD 70 Ton Ore Car Silver 20' Loaded Deep Hole Mine 53 21 85 Elk TTPX 80252 FB Loaded Lumber Store Loaded with Lumber Elk 49 BN 189784 XM Boxcar Green 40' Empty Track 1 Elk Yard 54 22 86 Elk TTPX 80316 FB Loaded Lumber Store Loaded with Lumber Elk 50 B&O 11147 XM Boxcar Yellow 50' Empty Track 1 Elk Yard 55 23 89 Elk ELK FM63234 FM Logs Logging Camp Loaded with Logs Elk 51 LV 41003 XM Boxcar white 40' Loaded Monument Mnf 56 24 90 Elk ELK FM63235 FM logs Logging Camp Loaded with Logs Elk 52 LV 41004 XM Boxcar white 40' Loaded Coop 57 25 93 Elk ELK FL1003 FL Logs Logging Camp 0 Elk 53 CN 553290 XAF BoxCar Brown 60' Empty Coop 58 94 Elk ELK FL1004 FL Logs Logging Camp 0 Elk 54 NW 47500 XM Boxcar Black 40' Empty Monument Mnf 59 95 Elk ELK FL1005 FL Logs Logging Camp 0 Elk 55 GN 20680 XM Boxcar Green 40' Loaded "Transfer n Storage" 60 Elk 56 GN 22020 XM Boxcar 40' Loaded "Transfer n Storage" 61 Elk 57 BN 3407 XM Boxcar Green 40' Loaded Oil Depot 62 Davis 58 WP 3301 XM Boxcar Brown 40' Loaded Davis 63 Davis 59 WP 61959 XM Boxcar Brown 40' Empty Davis 64 Davis 60 GN 11877 XM Boxcar Red 40' Empty Davis 65 Davis 61 VT 1015 XM Boxcar Brown 40' Empty Davis 66 Davis 62 rprx 507 RCD Refer Boxcar Yellow 40' Loaded Stock Yard 67 Davis 63 WA 3000 RCD Refer Boxcar Yellow 40' Empty Stock Yard 68 Elk 64 SF 55360 RCD Refer Boxcar Orange 50' Loaded Track 1 Elk Yard 69 Davis 65 SF 55361 RCD Refer Boxcar Orange 50' Loaded Meat Packing 70 Davis 66 LV RCD71120 RCD Refer Boxcar white 50' Empty Meat Packing 71 Elk 67 LV RCD71121 RCD Refer Boxcar white 50' Empty Track 2 Elk Yard 72 Davis 68 ELK RCD71122 RCD Refer Boxcar white 50' Loaded Davis 73 Davis 69 ELK RCD71123 RCD Refer Boxcar white 50' Loaded Davis 74 Elk 70 ELK RCD71124 RCD Refer Boxcar white 50' Empty Track 2 Elk Yard 75 Elk 71 WSRX 238 T Tank Car Brown 40' Empty Track 1 Elk Yard 76 Elk 72 SCCX 1245 T Tank Car Orange 40' Loaded Track 1 Elk Yard 77 Elk 73 GN 1153 T Tank Car Black 40' Empty Track 1 Elk Yard 78 Elk 74 SCCX 1246 T Tank Car Orange 40' Loaded Track 1 Elk Yard 79 Elk 75 SP 97732 TA Chemical Tank Car Silver 40' Empty Track 1 Elk Yard 80 Elk 76 UC 97778 TA Chemical Tank Car white 40' Loaded Track 2 Elk Yard 81 Elk 77 ATSF 582039 SM Stock Car (Cattle) Green 40' Empty Ranch 82 Elk 78 ELK SM52148 SM Stock Car (Cattle) Brown 40' Empty Ranch 83 Elk 79 D&RGW 62135 SM Stock Car (Cattle) Green 40' Empty Ranch 84 Elk 80 ATSF 50659 SM Stock Car (Cattle) Green 40' Loaded Ranch 85 Davis 81 UP 476306 SM Stock Car (Cattle) Yellow 40' Empty Stock Yard 86 Davis 82 UP 47758 SM Stock Car (Cattle) Yellow 40' Empty Stock Yard 87 Davis 83 UP 176306 SM Stock Car (Cattle) Yellow 40' Empty Stock Yard 88 Elk 84 CNW 15040 SH Stock Car (Horse) gr/ylw 40' Empty Ranch 89 Elk 85 TTPX 80252 FB Bulk Head Flat Car Brown 55' Loaded Lumber Store Loaded with Lumber 90 Elk 86 TTPX 80316 FB Bulk Head Flat Car Brown 55' Loaded Lumber Store Loaded with Lumber 91 Spokane 87 UP 59163 FM Flat Car Yellow 70' loaded Team Track Loaded with 2 Trailers 92 Spokane 88 NH 84217 FM Flat Car Black 70' Wire rolls Spokane Yard 93 Elk 89 ELK FM63234 FM Flat Car Black 70' Logs Logging Camp Loaded with Logs 94 Elk 90 ELK FM63235 FM Flat Car Black 70' logs Logging Camp Loaded with Logs 95 Davis 91 BN 66208 FM Flat Car Green 41' Rail load Davis Loaded with Rail 96 Davis 92 GN 66209 FM Flat Car Brown 41' Rail load Davis Loaded with Rail 97 Elk 93 ELK FL1003 FL Logging Car Black 40' Logs Logging Camp 98 Elk 94 ELK FL1004 FL Logging Car Black 40' Logs Logging Camp 99 Elk 95 ELK FL1005 FL Logging Car Black 40' Logs Logging Camp
Thanks for that. The problem is rows 31 & 32, if you clear them it will work
Fluff.xlsm A B C D E F G H I J K L M N O P Q R S T U 1 Date: 05/04/2024 2 SET OUTS 3 3 Train: #N/A Location: Elk 1 2 3 4 5 6 7 8 9 10 11 4 Location Rpt. Marks Number AAR Type LD/MTY Destination Notes Block ID Rpt. Marks Car No. Type Description Color Length LD/MTY Empty Return to 1 Notes 5 1 1 Elk UP 65263 GB Loaded Elk Track 2 0 Elk 1 UP 65263 GB Gondola Yellow 41' Loaded Elk Track 2 6 2 2 Elk SOUTHERN 1229 GB Loaded Elk Track 4 0 Elk 2 SOUTHERN 1229 GB Gondola Silver 41' Loaded Elk Track 4 7 3 6 Elk CO 218892 GB Loaded Elk Track 5 0 Spokane 3 SOUTHERN 1230 GB Gondola Silver 41' Empty Team Track 8 4 7 Elk ELK GB1230 GB Loaded Elk Track 5 0 Spokane 4 CN 1231 GB Gondola Red 41' Trash Team Track 9 5 8 Elk ELK GB1231 GB Empty Elk Track 5 0 Spokane 5 North 1232 GB Gondola Black 48' Trash Team Track 10 6 9 Elk ELK GB1232 GB Empty Elk Track 5 0 Elk 6 CO 218892 GB Gondola Black 41' Loaded Elk Track 5 11 7 10 Elk ELK GB1233 GB Empty Elk Track 5 0 Elk 7 ELK GB1230 GB Gondola Black 41' Loaded Elk Track 5 12 8 11 Elk ACF 5250 HT Loaded Coop 0 Elk 8 ELK GB1231 GB Gondola Black 41' Empty Elk Track 5 13 9 12 Elk ACF 5251 HT Loaded Coop 0 Elk 9 ELK GB1232 GB Gondola Black 41' Empty Elk Track 5 14 10 15 Elk PRR 262581 HT Empty Elk Track 2 0 Elk 10 ELK GB1233 GB Gondola Black 41' Empty Elk Track 5 15 11 19 Elk WA 32985 LO Empty Elk Track 4 0 Elk 11 ACF 5250 HT 4 Bay Hopper White 60' Loaded Coop 16 12 20 Elk WA 32986 LO Empty Elk Track 4 0 Elk 12 ACF 5251 HT 4 Bay Hopper White 60' Loaded Coop 17 13 21 Elk B&O 837085 LO Empty Elk Track 4 0 Spokane 13 ATSF 301488 HT 4 Bay Hopper Brown 60' Loaded Spokane Yard 18 14 22 Elk L&N 30069 LO Empty Elk Track 4 0 Spokane 14 ATSF 301489 HT 4 Bay Hopper Brown 60' Loaded Spokane Yard 19 15 38 Elk CN 114263 MWD Loaded Deep Hole Mine 0 Elk 15 PRR 262581 HT 4 Bay Hopper Brown 40' Empty Elk Track 2 20 16 39 Elk CN 114263 MWD Loaded Deep Hole Mine 0 Spokane 16 ELK HT1301 HT 4 Bay Hopper Black 62' Empty Team Track 21 17 40 Elk CN 114263 MWD Loaded Deep Hole Mine 0 Spokane 17 ELK HT1302 HT 4 Bay Hopper Black 62' Empty Team Track 22 18 41 Elk CN 114132 MWD Loaded Deep Hole Mine 0 Spokane 18 ELK HT1303 HT 4 Bay Hopper Black 62' Empty Team Track 23 19 42 Elk CN 114132 MWD Loaded Deep Hole Mine 0 Elk 19 WA 32985 LO 3 Bay Hopper Tan 45' Empty Elk Track 4 24 20 43 Elk UP 26440 MWD Loaded Deep Hole Mine 0 Elk 20 WA 32986 LO 3 Bay Hopper Tan 45' Empty Elk Track 4 25 21 44 Elk UP 26440 MWD Loaded Deep Hole Mine 0 Elk 21 B&O 837085 LO 3 Bay Hopper Gray 45' Empty Elk Track 4 26 22 45 Elk UP 26440 MWD Loaded Deep Hole Mine 0 Elk 22 L&N 30069 LO 3 Bay Hopper Brown 44' Empty Elk Track 4 27 23 46 Elk UP 26440 MWD Loaded Deep Hole Mine 0 Spokane 23 BN 521476 HT 90 Ton Hopper Black Loaded Spokane Yard 28 24 47 Elk UP 26440 MWD Loaded Deep Hole Mine 0 Spokane 24 BN 521477 HT 90 Ton Hopper Black Loaded Spokane Yard 29 25 48 Elk UP 26440 MWD Loaded Deep Hole Mine 0 Spokane 25 BN 521478 HT 90 Ton Hopper Black Loaded Spokane Yard 30 49 Elk BN 189784 XM Empty Track 1 Elk Yard 0 Spokane 26 BN 521479 HT 90 Ton Hopper Black Loaded Spokane Yard 31 50 Elk B&O 11147 XM Empty Track 1 Elk Yard 0 Spokane 27 BN 521480 HT 90 Ton Hopper Black Loaded Spokane Yard 32 51 Elk LV 41003 XM Loaded Monument Mnf 0 Spokane 28 BN 521481 HT 90 Ton Hopper Black Loaded Spokane Yard 33 1 52 Elk LV 41004 XM Loaded Coop 0 Spokane 29 BN 521482 HT 90 Ton Hopper Black Loaded Spokane Yard 34 2 53 Elk CN 553290 XAF Empty Coop 0 Spokane 30 BN 521483 HT 90 Ton Hopper Black Loaded Spokane Yard 35 3 54 Elk NW 47500 XM Empty Monument Mnf 0 Spokane 31 MKT 10683 HT 90 Ton Hopper Black Loaded Spokane Yard 36 4 55 Elk GN 20680 XM Loaded "Transfer n Storage" 0 Spokane 32 BN 163210 HT 90 Ton Hopper Red Loaded Spokane Yard 37 5 56 Elk GN 22020 XM Loaded "Transfer n Storage" 0 Spokane 33 RG 17491 HT 90 Ton Hopper black Loaded Spokane Yard 38 6 57 Elk BN 3407 XM Loaded Oil Depot 0 Spokane 34 BN 163210 HT 90 Ton Hopper Alum. Loaded Spokane Yard 39 7 64 Elk SF 55360 RCD Loaded Track 1 Elk Yard 0 Davis 35 ELK HM 2 Bay Hopper Black Empty Lumber Mill 40 8 67 Elk LV RCD71121 RCD Empty Track 2 Elk Yard 0 Davis 36 GN 176857 HM 2 Bay Hopper Gray 20' Empty Lumber Mill 41 9 70 Elk ELK RCD71124 RCD Empty Track 2 Elk Yard 0 Davis 37 GN 176858 HM 2 Bay Hopper White 20' Empty Lumber Mill 42 10 71 Elk WSRX 238 T Empty Track 1 Elk Yard 0 Elk 38 CN 114263 MWD 70 Ton Ore Car Brown 20' Loaded Deep Hole Mine 43 11 72 Elk SCCX 1245 T Loaded Track 1 Elk Yard 0 Elk 39 CN 114263 MWD 70 Ton Ore Car Brown 20' Loaded Deep Hole Mine 44 12 73 Elk GN 1153 T Empty Track 1 Elk Yard 0 Elk 40 CN 114263 MWD 70 Ton Ore Car Brown 20' Loaded Deep Hole Mine 45 13 74 Elk SCCX 1246 T Loaded Track 1 Elk Yard 0 Elk 41 CN 114132 MWD 70 Ton Ore Car Brown 20' Loaded Deep Hole Mine 46 14 75 Elk SP 97732 TA Empty Track 1 Elk Yard 0 Elk 42 CN 114132 MWD 70 Ton Ore Car Brown 20' Loaded Deep Hole Mine 47 15 76 Elk UC 97778 TA Loaded Track 2 Elk Yard 0 Elk 43 UP 26440 MWD 70 Ton Ore Car Silver 20' Loaded Deep Hole Mine 48 16 77 Elk ATSF 582039 SM Empty Ranch 0 Elk 44 UP 26440 MWD 70 Ton Ore Car Silver 20' Loaded Deep Hole Mine 49 17 78 Elk ELK SM52148 SM Empty Ranch 0 Elk 45 UP 26440 MWD 70 Ton Ore Car Silver 20' Loaded Deep Hole Mine 50 18 79 Elk D&RGW 62135 SM Empty Ranch 0 Elk 46 UP 26440 MWD 70 Ton Ore Car Silver 20' Loaded Deep Hole Mine 51 19 80 Elk ATSF 50659 SM Loaded Ranch 0 Elk 47 UP 26440 MWD 70 Ton Ore Car Silver 20' Loaded Deep Hole Mine 52 20 84 Elk CNW 15040 SH Empty Ranch 0 Elk 48 UP 26440 MWD 70 Ton Ore Car Silver 20' Loaded Deep Hole Mine 53 21 85 Elk TTPX 80252 FB Loaded Lumber Store Loaded with Lumber Elk 49 BN 189784 XM Boxcar Green 40' Empty Track 1 Elk Yard 54 22 86 Elk TTPX 80316 FB Loaded Lumber Store Loaded with Lumber Elk 50 B&O 11147 XM Boxcar Yellow 50' Empty Track 1 Elk Yard 55 23 89 Elk ELK FM63234 FM Logs Logging Camp Loaded with Logs Elk 51 LV 41003 XM Boxcar white 40' Loaded Monument Mnf 56 24 90 Elk ELK FM63235 FM logs Logging Camp Loaded with Logs Elk 52 LV 41004 XM Boxcar white 40' Loaded Coop 57 25 93 Elk ELK FL1003 FL Logs Logging Camp 0 Elk 53 CN 553290 XAF BoxCar Brown 60' Empty Coop 58 94 Elk ELK FL1004 FL Logs Logging Camp 0 Elk 54 NW 47500 XM Boxcar Black 40' Empty Monument Mnf 59 95 Elk ELK FL1005 FL Logs Logging Camp 0 Elk 55 GN 20680 XM Boxcar Green 40' Loaded "Transfer n Storage" 60 Elk 56 GN 22020 XM Boxcar 40' Loaded "Transfer n Storage" 61 Elk 57 BN 3407 XM Boxcar Green 40' Loaded Oil Depot 62 Davis 58 WP 3301 XM Boxcar Brown 40' Loaded Davis 63 Davis 59 WP 61959 XM Boxcar Brown 40' Empty Davis 64 Davis 60 GN 11877 XM Boxcar Red 40' Empty Davis 65 Davis 61 VT 1015 XM Boxcar Brown 40' Empty Davis 66 Davis 62 rprx 507 RCD Refer Boxcar Yellow 40' Loaded Stock Yard 67 Davis 63 WA 3000 RCD Refer Boxcar Yellow 40' Empty Stock Yard 68 Elk 64 SF 55360 RCD Refer Boxcar Orange 50' Loaded Track 1 Elk Yard 69 Davis 65 SF 55361 RCD Refer Boxcar Orange 50' Loaded Meat Packing 70 Davis 66 LV RCD71120 RCD Refer Boxcar white 50' Empty Meat Packing 71 Elk 67 LV RCD71121 RCD Refer Boxcar white 50' Empty Track 2 Elk Yard 72 Davis 68 ELK RCD71122 RCD Refer Boxcar white 50' Loaded Davis 73 Davis 69 ELK RCD71123 RCD Refer Boxcar white 50' Loaded Davis 74 Elk 70 ELK RCD71124 RCD Refer Boxcar white 50' Empty Track 2 Elk Yard 75 Elk 71 WSRX 238 T Tank Car Brown 40' Empty Track 1 Elk Yard 76 Elk 72 SCCX 1245 T Tank Car Orange 40' Loaded Track 1 Elk Yard 77 Elk 73 GN 1153 T Tank Car Black 40' Empty Track 1 Elk Yard 78 Elk 74 SCCX 1246 T Tank Car Orange 40' Loaded Track 1 Elk Yard 79 Elk 75 SP 97732 TA Chemical Tank Car Silver 40' Empty Track 1 Elk Yard 80 Elk 76 UC 97778 TA Chemical Tank Car white 40' Loaded Track 2 Elk Yard 81 Elk 77 ATSF 582039 SM Stock Car (Cattle) Green 40' Empty Ranch 82 Elk 78 ELK SM52148 SM Stock Car (Cattle) Brown 40' Empty Ranch 83 Elk 79 D&RGW 62135 SM Stock Car (Cattle) Green 40' Empty Ranch 84 Elk 80 ATSF 50659 SM Stock Car (Cattle) Green 40' Loaded Ranch 85 Davis 81 UP 476306 SM Stock Car (Cattle) Yellow 40' Empty Stock Yard 86 Davis 82 UP 47758 SM Stock Car (Cattle) Yellow 40' Empty Stock Yard 87 Davis 83 UP 176306 SM Stock Car (Cattle) Yellow 40' Empty Stock Yard 88 Elk 84 CNW 15040 SH Stock Car (Horse) gr/ylw 40' Empty Ranch 89 Elk 85 TTPX 80252 FB Bulk Head Flat Car Brown 55' Loaded Lumber Store Loaded with Lumber 90 Elk 86 TTPX 80316 FB Bulk Head Flat Car Brown 55' Loaded Lumber Store Loaded with Lumber 91 Spokane 87 UP 59163 FM Flat Car Yellow 70' loaded Team Track Loaded with 2 Trailers 92 Spokane 88 NH 84217 FM Flat Car Black 70' Wire rolls Spokane Yard 93 Elk 89 ELK FM63234 FM Flat Car Black 70' Logs Logging Camp Loaded with Logs 94 Elk 90 ELK FM63235 FM Flat Car Black 70' logs Logging Camp Loaded with Logs 95 Davis 91 BN 66208 FM Flat Car Green 41' Rail load Davis Loaded with Rail 96 Davis 92 GN 66209 FM Flat Car Brown 41' Rail load Davis Loaded with Rail 97 Elk 93 ELK FL1003 FL Logging Car Black 40' Logs Logging Camp 98 Elk 94 ELK FL1004 FL Logging Car Black 40' Logs Logging Camp 99 Elk 95 ELK FL1005 FL Logging Car Black 40' Logs Logging Camp
This is great, Thank you for your help.
Thanks for your patience, and teaching me a few things.
Steve.
You're welcome & thanks for the feedback.
Threads
1,216,005
Messages
6,128,231
Members
449,435
Latest member
Jahmia0616