Hi
In your example file, add a new sheet called sheet1.
Put the code below into a general module, and run. I doesn't fill out the FS column. I'm guessing that the FS comes from say the Monday column of data, but given the example output I can't be sure. I can't see where the FS of 2,77 comes from for BDLJFK02. Should it be 0,00?
I'm also not sure if this code groups on enough data and it is a quirk of the example data that allows the results to work. Can you expand your data sample to cover a wider range if it doesn't work.
rylo
Bookmarks