I need to develop an Excel worksheet that will automatically 'build' orchid names from a list. (list is provided)
The user will search from a drop-down menu list and insert the names, by choosing several names from the list, the full title can be built.
I have managed to build a prototype that can do half the job, but this needs to be improved on.
Here is a part of the names list...........
The user will select names & built up the full names as shown...
Choc Valley 'Classic'
(Choc Valley x Classic)
Choc Valley 'Classic' x Claude Pepper
Choc Valley 'Classic' x Claude Pepper 'Comet'
(Choc Valley x Classic) x (Claude Pepper x Comet)
You will see that the same names make up the individual names of plants. Attention needs to be given to the attributes like () & ', x.
I have built a sample that will build the 1st, 3rd & 4th samples above, but I need to implement the parenthesis option & allow for additional editing if required. Please contact me for the Excel sample & we can discuss this more.
Job will only be paid for when it is finished, no advanced payments or escrow.