Hi All,
I'll present my three worksheets first and explain afterwards. I think showing the starting condition and the end condition makes it easier to show what I'm after.
The times in B of Unfinished/Final Form can be ignored as far as I understand.
To create the "Final Form" I am simply looking at the part # and Time Slot in A and then finding a match in Source.
If there's no match, its blank and moves on to the next time slot.
If there is a match, the the result is the rad (random associated data) in Source C - I believe this will need to utilize the offset function as this is just an example sheet - the actual data im working with is likely to be in a different column.
I also appreciate the layout of Unfinished/Final Form might be considered a bit weird as the only header information is in A1:B2 and there are no headers at all in the Source data.
Also Final Form looks like an ugly, haphazard way of presenting the data, but for my purposes it makes a lot of sense once totally finished
I should also say that the Source data goes down to an unknown row (its variable) but the same part number should never occur more than once in the same time slot (if it does, the problem is more serious than just this workbook lol).
Any help on writing the code for this would be appreciated. I thought about creating a scripting dictionary which contains the source data but I'm not sure that will help... alternatively I know how I would do it with a formula using If, And, Match, and Offset - but that would result in a lot of formulas and just be completely horrible so its a non-starter.
Thanks for any help!
I'll present my three worksheets first and explain afterwards. I think showing the starting condition and the end condition makes it easier to show what I'm after.
| Book2 | |||||||||
|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | |||
| 1 | Part # > | 101010 | 43250 | 23 | 98451 | 1289 | |||
| 2 | Time Slot | ||||||||
| 3 | 06/01/2022 06:30 | 06/01/2022 06:45 | |||||||
| 4 | 06/01/2022 06:45 | 06/01/2022 07:00 | |||||||
| 5 | 06/01/2022 07:00 | 06/01/2022 07:15 | |||||||
| 6 | 06/01/2022 07:15 | 06/01/2022 07:30 | |||||||
| 7 | 06/01/2022 07:30 | 06/01/2022 07:45 | |||||||
| 8 | … | … | |||||||
| 9 | 07/01/2022 06:15 | 07/01/2022 06:30 | |||||||
Unfinished | |||||||||
| Book2 | |||||
|---|---|---|---|---|---|
| A | B | C | |||
| 1 | 101010 | 06/01/2022 06:30 | Rad | ||
| 2 | 43250 | 06/01/2022 06:30 | Chickens | ||
| 3 | 23 | 06/01/2022 06:30 | 42 | ||
| 4 | 101010 | 06/01/2022 07:00 | Batman | ||
| 5 | 98451 | 06/01/2022 07:00 | A Hat | ||
| 6 | 1289 | 06/01/2022 07:00 | Richard Hammond | ||
| 7 | 1289 | 06/01/2022 07:30 | Flamingo | ||
| 8 | … | … | … | ||
| 9 | 23 | 07/01/2022 06:15 | Sprouts | ||
Source | |||||
| Book2 | |||||||||
|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | |||
| 1 | Part # > | 101010 | 43250 | 23 | 98451 | 1289 | |||
| 2 | Time Slot | ||||||||
| 3 | 06/01/2022 06:30 | 06/01/2022 06:45 | Rad | Chickens | 42 | ||||
| 4 | 06/01/2022 06:45 | 06/01/2022 07:00 | |||||||
| 5 | 06/01/2022 07:00 | 06/01/2022 07:15 | Batman | A Hat | Richard Hammond | ||||
| 6 | 06/01/2022 07:15 | 06/01/2022 07:30 | |||||||
| 7 | 06/01/2022 07:30 | 06/01/2022 07:45 | Flamingo | ||||||
| 8 | … | … | |||||||
| 9 | 07/01/2022 06:15 | 07/01/2022 06:30 | Sprouts | ||||||
Final Form | |||||||||
The times in B of Unfinished/Final Form can be ignored as far as I understand.
To create the "Final Form" I am simply looking at the part # and Time Slot in A and then finding a match in Source.
If there's no match, its blank and moves on to the next time slot.
If there is a match, the the result is the rad (random associated data) in Source C - I believe this will need to utilize the offset function as this is just an example sheet - the actual data im working with is likely to be in a different column.
I also appreciate the layout of Unfinished/Final Form might be considered a bit weird as the only header information is in A1:B2 and there are no headers at all in the Source data.
Also Final Form looks like an ugly, haphazard way of presenting the data, but for my purposes it makes a lot of sense once totally finished
I should also say that the Source data goes down to an unknown row (its variable) but the same part number should never occur more than once in the same time slot (if it does, the problem is more serious than just this workbook lol).
Any help on writing the code for this would be appreciated. I thought about creating a scripting dictionary which contains the source data but I'm not sure that will help... alternatively I know how I would do it with a formula using If, And, Match, and Offset - but that would result in a lot of formulas and just be completely horrible so its a non-starter.
Thanks for any help!
