mackensteff
Board Regular
- Joined
- Feb 9, 2010
- Messages
- 74
- Office Version
- 365
- Platform
- MacOS
Hello,
My goal is to have a macro copy a known range (columns A:L in picture), sort them by the values typed in the yellow boxes in column M, paste the values starting in column N, ignoring null values, and then paste the format to match columns A:L.
I have include a picture of the desired for results as well as data if anyone is willing to try this out.
I appreciate your time!!
<tbody>
</tbody>
My goal is to have a macro copy a known range (columns A:L in picture), sort them by the values typed in the yellow boxes in column M, paste the values starting in column N, ignoring null values, and then paste the format to match columns A:L.
I have include a picture of the desired for results as well as data if anyone is willing to try this out.
I appreciate your time!!
Bib | Last, First | Name | DivPl | SexPl | Time | Division | School | Grade | Score | TeamPos. | TeamPlace | Sort 1st | Bib | Last, First | Name | DivPl | SexPl | Time | Division | School | Grade | Score | TeamPos. | TeamPlace |
137 | Green, Noah | Kober, Maia | 42 | 90 | 18:41 | Boys: JV | Cedar | 10 | 35 | 6 | 4th Place | School | 44 | Blake, Luke | Chastain, Chara | 61 | 118 | 19:13 | Boys: JV | Canyon View | 12 | NS | 10 | 3rd Place |
117 | Coates, Branson | Basnett, Marilu | 43 | 91 | 18:41 | Boys: JV | Cedar | 10 | 36 | 7 | 4th Place | Sort 2nd | 49 | Jarvis, Paul | Tompson, Eugenie | 47 | 98 | 18:53 | Boys: JV | Canyon View | 10 | NS | 8 | 3rd Place |
204 | Sandberg, Jack | Moree, Lashonda | 44 | 92 | 18:41 | Boys: JV | Desert Hills | 10 | NS | 9 | 1st Place | Division | 36 | Valenzuela, Eddie | Bechard, Emerson | 52 | 108 | 19:07 | Boys: JV | Canyon View | 10 | NS | 9 | 3rd Place |
111 | Webster, Mic | Keffer, Merrill | 4 | 4 | 18:45 | Girls: Varsity | Cedar | 11 | 4 | 1 | 3rd Place | Sort 3rd | 117 | Coates, Branson | Basnett, Marilu | 43 | 91 | 18:41 | Boys: JV | Cedar | 10 | 36 | 7 | 4th Place |
205 | Hendrix, Jaron | Nale, Kesha | 45 | 93 | 18:46 | Boys: JV | Desert Hills | 10 | NS | 10 | 1st Place | Last, First | 137 | Green, Noah | Kober, Maia | 42 | 90 | 18:41 | Boys: JV | Cedar | 10 | 35 | 6 | 4th Place |
292 | Dansie, Porter | Mendoza, Juliet | 46 | 94 | 18:46 | Boys: JV | Hurricane | 10 | 37 | 5 | 5th Place | 114 | Prince, Austin | Gayles, Bret | 59 | 116 | 19:12 | Boys: JV | Cedar | 10 | NS | 8 | 4th Place | |
259 | Barker, Corbyn | Pelley, Vonnie | 49 | 95 | 18:46 | Boys: Varsity | Dixie | 10 | 49 | 3 | 8th Place | 205 | Hendrix, Jaron | Nale, Kesha | 45 | 93 | 18:46 | Boys: JV | Desert Hills | 10 | NS | 10 | 1st Place | |
260 | Wells, George | Pool, Jung | 50 | 95 | 18:46 | Boys: Varsity | Dixie | 12 | 50 | 4 | 8th Place | 207 | Messel, Jordan | Wegman, Edwina | 57 | 114 | 19:10 | Boys: JV | Desert Hills | 10 | NS | 12 | 1st Place | |
264 | Wilkinson, Tate | Mcquire, Ronda | 51 | 97 | 18:48 | Boys: Varsity | Dixie | 11 | 51 | 5 | 8th Place | 204 | Sandberg, Jack | Moree, Lashonda | 44 | 92 | 18:41 | Boys: JV | Desert Hills | 10 | NS | 9 | 1st Place | |
108 | Taylor, Harley | States, Sam | 5 | 5 | 18:52 | Girls: Varsity | Cedar | 11 | 5 | 2 | 3rd Place | 254 | Carlile, Spencer | Dolby, Tonya | 62 | 119 | 19:15 | Boys: JV | Dixie | 9 | 47 | 4 | 7th Place | |
49 | Jarvis, Paul | Tompson, Eugenie | 47 | 98 | 18:53 | Boys: JV | Canyon View | 10 | NS | 8 | 3rd Place | 292 | Dansie, Porter | Mendoza, Juliet | 46 | 94 | 18:46 | Boys: JV | Hurricane | 10 | 37 | 5 | 5th Place | |
36 | Valenzuela, Eddie | Bechard, Emerson | 52 | 108 | 19:07 | Boys: JV | Canyon View | 10 | NS | 9 | 3rd Place | 443 | Hall, Hunter | Peer, Kristian | 58 | 115 | 19:10 | Boys: JV | Snow Canyon | 9 | 45 | 1 | 8th Place | |
500 | Curtis, Nathan | Kratky, Lilliana | 53 | 109 | 19:07 | Boys: JV | Wasatch | 10 | 41 | 3 | 6th Place | 500 | Curtis, Nathan | Kratky, Lilliana | 53 | 109 | 19:07 | Boys: JV | Wasatch | 10 | 41 | 3 | 6th Place | |
485 | Patterson, Braden | Nystrom, Sachiko | 54 | 110 | 19:08 | Boys: JV | Wasatch | 11 | 42 | 4 | 6th Place | 498 | Davis, McCall | Foulds, Randell | 55 | 111 | 19:08 | Boys: JV | Wasatch | 11 | 43 | 5 | 6th Place | |
498 | Davis, McCall | Foulds, Randell | 55 | 111 | 19:08 | Boys: JV | Wasatch | 11 | 43 | 5 | 6th Place | 486 | Jarvis, Caeden | Laureano, Linh | 56 | 113 | 19:09 | Boys: JV | Wasatch | 9 | 44 | 6 | 6th Place | |
505 | McCullough, Ben | Fregoso, Stepanie | 57 | 112 | 19:09 | Boys: Varsity | Wasatch | 11 | 57 | 7 | 6th Place | 485 | Patterson, Braden | Nystrom, Sachiko | 54 | 110 | 19:08 | Boys: JV | Wasatch | 11 | 42 | 4 | 6th Place | |
486 | Jarvis, Caeden | Laureano, Linh | 56 | 113 | 19:09 | Boys: JV | Wasatch | 9 | 44 | 6 | 6th Place | 259 | Barker, Corbyn | Pelley, Vonnie | 49 | 95 | 18:46 | Boys: Varsity | Dixie | 10 | 49 | 3 | 8th Place | |
207 | Messel, Jordan | Wegman, Edwina | 57 | 114 | 19:10 | Boys: JV | Desert Hills | 10 | NS | 12 | 1st Place | 260 | Wells, George | Pool, Jung | 50 | 95 | 18:46 | Boys: Varsity | Dixie | 12 | 50 | 4 | 8th Place | |
443 | Hall, Hunter | Peer, Kristian | 58 | 115 | 19:10 | Boys: JV | Snow Canyon | 9 | 45 | 1 | 8th Place | 264 | Wilkinson, Tate | Mcquire, Ronda | 51 | 97 | 18:48 | Boys: Varsity | Dixie | 11 | 51 | 5 | 8th Place | |
114 | Prince, Austin | Gayles, Bret | 59 | 116 | 19:12 | Boys: JV | Cedar | 10 | NS | 8 | 4th Place | 344 | Krzymowski, Tim | Ramey, Stanley | 56 | 107 | 19:07 | Boys: Varsity | Manti | 12 | 56 | 2 | 9th Place | |
293 | Poston, Tatyn | Goold, Barb | 60 | 117 | 19:12 | Boys: JV | Hurricane | 11 | 46 | 7 | 5th Place | 505 | McCullough, Ben | Fregoso, Stepanie | 57 | 112 | 19:09 | Boys: Varsity | Wasatch | 11 | 57 | 7 | 6th Place | |
44 | Blake, Luke | Chastain, Chara | 61 | 118 | 19:13 | Boys: JV | Canyon View | 12 | NS | 10 | 3rd Place | 108 | Taylor, Harley | States, Sam | 5 | 5 | 18:52 | Girls: Varsity | Cedar | 11 | 5 | 2 | 3rd Place | |
374 | Finch, Jacey | Ree, Olen | 7 | 7 | 19:14 | Girls: Varsity | Pine View | 12 | 7 | 3 | 1st Place | 111 | Webster, Mic | Keffer, Merrill | 4 | 4 | 18:45 | Girls: Varsity | Cedar | 11 | 4 | 1 | 3rd Place | |
254 | Carlile, Spencer | Dolby, Tonya | 62 | 119 | 19:15 | Boys: JV | Dixie | 9 | 47 | 4 | 7th Place | 374 | Finch, Jacey | Ree, Olen | 7 | 7 | 19:14 | Girls: Varsity | Pine View | 12 | 7 | 3 | 1st Place | |
<tbody>
</tbody>