|Thanks for the Row and Column headings. They really help.|
OK, I think we have a number of issues and it may because of the paste you did. Remember, I don't want to offer any code or suggestions until I am sure that the example data that I am looking at is correct. I think you need to look very closely at the example data you've posted and make sure it is correct. I'm seeing many indications that it is not.
I am ssuming that the Column bewteen F and H is G, not GD as shown in your post.
Are the ship names in Column B or C?
You said: "I cannot account for why the first "GD" isn't showing up in cell D2 in this paste - it is in the spreadsheet."
My guess is that the paste inserted a "tab" after CHARLESTONSC and everything is shifted one column to the right.
You said: "The first first patrol period for that ship goes from hour zero (cell D1) to hour 3000 (cell AD1)"
If you scroll your post out to cells AC1/AD1 you'll see that the 3000 is showing in AC1, not AD1. Please clarify.
I've asked this before, but haven't seen a response, so I'll ask it again, this time using the cell references provided:
In Row 3, for "C-05 CHARLESTONSC" there is a C in Z3 (under 2640), but your output in Row 26 shows:
A B C D E F
26 C-05 CHARLESTONSC 2520 3960 CD
Why isn't there a C in F26, instead of a CD?
What is the DS in D3 for? You don't show it in your output, yet it appears under the 0 start time.
Similar question for the DD in Row 4. Is the DD part of the name "NORFOLK DD" or is it supposed to be in some other column?
I suspect that your columns ae not line up correctly because of the way the data was pasted into this forum's editor. I suspect that there are tabs between some columns and it is messing with the alignment.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.