Hi everyone.
I have been trying to help myself as much as I can, however, I have spent too much time on this and now I am rushing to get it done which is making it worse.
What I am trying to accomplish is to be able to enter/select a category which will limit the service list to the items within that category. Once that line is populated I am using a vlookup to fill out the MRC/NRC fields in order to get the values associated with the product/equipment
Whenever I type something into the service field (Row E is the only one working) I cannot click the drop down handle and see my results. I have to exit the field and come back and click the drop down for the values to be available.
I eventually will add command buttons to add/delete rows, etc but right now I am just trying to nail down the main functionality so I can come up with an accurate quote which I can turn into admin to create an accurate order (part #'s, descriptions)
https://www.dropbox.com/sh/l16stswtyp2a5u7/AAC48HdeIl6Yo3t0IVwSyNG8a?dl=0
I have been trying to help myself as much as I can, however, I have spent too much time on this and now I am rushing to get it done which is making it worse.
What I am trying to accomplish is to be able to enter/select a category which will limit the service list to the items within that category. Once that line is populated I am using a vlookup to fill out the MRC/NRC fields in order to get the values associated with the product/equipment
Whenever I type something into the service field (Row E is the only one working) I cannot click the drop down handle and see my results. I have to exit the field and come back and click the drop down for the values to be available.
I eventually will add command buttons to add/delete rows, etc but right now I am just trying to nail down the main functionality so I can come up with an accurate quote which I can turn into admin to create an accurate order (part #'s, descriptions)
https://www.dropbox.com/sh/l16stswtyp2a5u7/AAC48HdeIl6Yo3t0IVwSyNG8a?dl=0
Last edited:
