0
Worksheet 1 lists all of the "legs" flown by our aircraft. The leg or legs for each day would then go to Worksheet 2 for Day 1, Worksheet 3 for Day 2, and so on. Legs are listed in columns starting with leg 1, then leg 2, and so on. Each leg has a date in the top cell. I'm creating a workbook that will take the leg(s) on each day and transpose the information from that flight to another worksheet (Day 1, Day 2,...). The problem I'm running into is a day's flights could be 1 leg, to 5-6 legs. There are 24 columns that cover a period of about 2 weeks. Each "Day" worksheet only has 8 columns since we'd never fly more than 8 legs in a day. The day 1 worksheet is easy, but on day 2 i run into problems. I'm currently using a combination of IF & AND functions to write the formula to determine which is the next date it should enter. But I just can't get it to work the way i want. I'll try to type out an example below that hopefully clears this muddy water up.
MASTER TRIP WORKSHEET
LEG 1___LEG 2___LEG 3___LEG 4___LEG 5___LEG 6
8/5______8/6______8/6_____8/7______8/7_____8/8
CAK_____PLN_____APA____ASE_____ADS_____DAL
PLN_____APA_____ASE____ADS_____DAL_____SUN
DAY 1 WORKSHEET
LEG 1
8/5
CAK
PLN
DAY 2 WORKSHEET
LEG 2___LEG 3
8/6______8/6
PLN______APA
APA______ASE
DAY 3 WORKSHEET
LEG 4___LEG 5
8/7______8/7
ASE______ADS
ADS______DAL
DAY 4 WORKSHEET
LEG 6
8/8
DAL
SUN
So the Day 1, Day 2... worksheets need to only grab the next NEW dates (and again, this could be 1 to 8 legs on each individual worksheet). I've figured out how to move all the leg information over, i JUST need to be able to separate the dates onto the correct worksheets.
Please let me know if this isn't clear enough. AND THANK YOU!!
Wow, that's a very nice way to do what I needed. Thank you very much for your help!! – user364679 – 2014-09-04T02:21:00.250
Okay, one more issue. I understand how this works for the first column on the subsequent days, but the B2 thru H2 formula has an issue, what if the cells aren't directly next to each other? Some of these are merged. So it's not really B2, the "big" first formula is actually going in cell D9, then the next leg is cell H9, then L9, etc. So it's not looking in the column directly beside it, it's looking 4 to the left. – user364679 – 2014-09-17T11:48:54.887