Thank you for looking at this issue for me Paul. Not sure why the TblCount went missing but is now available in the latest version.
The first part of this workbook is just about getting the Cell E4 to show either "Monitor" or "Treat". There are 4 phases in a Colony and when compared to the Mite % will determine if the hive needs to be treated or not. I've tried Index/Match and XLookup but get errors. If Cell E4 shows "Monitor" then Questions 3 & 4 don't need to be answered. Greyed out or not visible perhaps. Can anyone show me how to do this correctly please?
The second part is where I'd like to show relevant data somewhere to right of Column E (I'm still thinking about how this might be done), any chemical options that are available to the beekeeper from TblProducts. I had hoped to simply filter certain columns out depending on whether the chemical may be used or not.
For example Question 3 asks if supers are on, and if the answer is "No" then all chemicals may be shown. However if the answer is "Yes" then Chemicals (Apitraz, Apivar, Apistan & Apiguard) should not be shown.
And to add a further kicker to this.... If the answer to Q4 is anything other than "None", then that particular chemical that was previously used may not be shown as an option. We are not allowed to use any chemical in a sequential treatment as a method of slowing resistance to treatments. If you are a beekeeper you will understand the last bit.
Reply With Quote