Hi all,
Im completely new to the forum, stubbled on it as most of my google searches seemed to bring me here! So I hope that its not too cheeky to dive right in and ask for some help! Sorry if it is
Basically I have two sets of data. One that states a job needs to be done, the other states what jobs have been completed. I want to be ale to use the second set of data to check what still needs to be done on the first set.
Problem is that the two sets of data are formatted differently when I receive them. I'm stumped and don't know if this is possible or not.
The "to do list" looks like this:
108605 MultiStripe
(where the number and the text are in two cells).
The "done list" looks like this:
[TABLE="width: 514"]
<tbody>[TR]
[TD]106856_618_E_MultiStripe_PolperroDuvetCoverSet_14HA
(and is obviously all in one cell)
If anyone has any ideas on how I could go about this I would be in your debt!
Thanks a bunch and let me know if I have left any info out![/TD]
[/TR]
</tbody>[/TABLE]
Im completely new to the forum, stubbled on it as most of my google searches seemed to bring me here! So I hope that its not too cheeky to dive right in and ask for some help! Sorry if it is
Basically I have two sets of data. One that states a job needs to be done, the other states what jobs have been completed. I want to be ale to use the second set of data to check what still needs to be done on the first set.
Problem is that the two sets of data are formatted differently when I receive them. I'm stumped and don't know if this is possible or not.
The "to do list" looks like this:
108605 MultiStripe
(where the number and the text are in two cells).
The "done list" looks like this:
[TABLE="width: 514"]
<tbody>[TR]
[TD]106856_618_E_MultiStripe_PolperroDuvetCoverSet_14HA
(and is obviously all in one cell)
If anyone has any ideas on how I could go about this I would be in your debt!
Thanks a bunch and let me know if I have left any info out![/TD]
[/TR]
</tbody>[/TABLE]
