Hello all,
I've been searching for around an hour and can't seem to find my exact problem. That said, apologies if this has already been answered elsewhere.
As per the guidelines for posting, my excel version is 2010.
I have the following;
<TBODY>
</TBODY>
I'd like to take each of the 'Description' numbers, 169200 for example, and loop through them all, returning a list which contains the 'Description', 'Start Time' and 'End Time' field, like below;
<TBODY>
</TBODY>
This would carry on until we run out of 'Description' cells, I haven't completed the table here as it's unneccessary. It doesn't matter whether the loop runs horizontal and then vertical or the other way around, just as long as the data is returned in the format above.
To complicate matters further, the number of entries under 'Description' will vary as will the number of entries under 'Name' - essentially the number of rows and columns will be dynamic and I've chosen the example above to try to demonstrate this. Also, there will be duplicate entries under 'Description' which may have different 'Start Time' and 'End Time' as in the example of 169200 above.
I'm pretty much out of my depth here, and I don't really know where to start or indeed if what I'm after is even possible. Any help anyone can offer would be hugely appreciated.
Many thanks in advance for anyone who can shine any light on this.
I've been searching for around an hour and can't seem to find my exact problem. That said, apologies if this has already been answered elsewhere.
As per the guidelines for posting, my excel version is 2010.
I have the following;
Name | Start Time | End Time | Description | |||||||||||
37-S01 HHH |
<TBODY> </TBODY> |
<TBODY> </TBODY> |
<TBODY> </TBODY> |
<TBODY> </TBODY> | ||||||||||
37-S02 FJG |
<TBODY> </TBODY> |
<TBODY> </TBODY> |
<TBODY> </TBODY> | |||||||||||
37-S03 EED |
<TBODY> </TBODY> |
<TBODY> </TBODY> |
<TBODY> </TBODY> |
<TBODY> </TBODY> | ||||||||||
37-S04 OFP |
<TBODY> </TBODY> |
<TBODY> </TBODY> |
<TBODY> </TBODY> | |||||||||||
37-S05 JMM |
<TBODY> </TBODY> |
<TBODY> </TBODY> |
<TBODY> </TBODY> |
<TBODY> </TBODY> | ||||||||||
37-S06 TIG |
<TBODY> </TBODY> |
<TBODY> </TBODY> |
<TBODY> </TBODY> |
<TBODY> </TBODY> |
<TBODY> </TBODY> |
<TBODY> </TBODY> |
<TBODY> </TBODY> | |||||||
37-S07 QIN |
<TBODY> </TBODY> |
<TBODY> </TBODY> |
<TBODY> </TBODY> |
<TBODY> </TBODY> | ||||||||||
<TBODY>
</TBODY>
I'd like to take each of the 'Description' numbers, 169200 for example, and loop through them all, returning a list which contains the 'Description', 'Start Time' and 'End Time' field, like below;
<TBODY> </TBODY> |
<TBODY> </TBODY> |
<TBODY> </TBODY> | |||
<TBODY> </TBODY> |
<TBODY> </TBODY> |
<TBODY> </TBODY> | |||
<TBODY> </TBODY> |
<TBODY> </TBODY> |
<TBODY> </TBODY> | |||
<TBODY> </TBODY> |
<TBODY> </TBODY> |
<TBODY> </TBODY> | |||
<TBODY> </TBODY> |
<TBODY> </TBODY> |
<TBODY> </TBODY> |
<TBODY>
</TBODY>
This would carry on until we run out of 'Description' cells, I haven't completed the table here as it's unneccessary. It doesn't matter whether the loop runs horizontal and then vertical or the other way around, just as long as the data is returned in the format above.
To complicate matters further, the number of entries under 'Description' will vary as will the number of entries under 'Name' - essentially the number of rows and columns will be dynamic and I've chosen the example above to try to demonstrate this. Also, there will be duplicate entries under 'Description' which may have different 'Start Time' and 'End Time' as in the example of 169200 above.
I'm pretty much out of my depth here, and I don't really know where to start or indeed if what I'm after is even possible. Any help anyone can offer would be hugely appreciated.
Many thanks in advance for anyone who can shine any light on this.
Last edited: