Hi everyone,
this is quite a difficult one i think, so here goes.
i want to know if its possible to search for an item and relative price based on a customer selection.
i have a form that my sales guys use for price changes and i want to link it too our database, now when the select the customer account number and add a product code in itll show
the specific item as well as in another cell show the live price.
im not sure if this can be done with a simple formula or will have to go down the whole VBA route
i hope i have covered enough information. if you need anything else please let me know.
this is quite a difficult one i think, so here goes.
i want to know if its possible to search for an item and relative price based on a customer selection.
i have a form that my sales guys use for price changes and i want to link it too our database, now when the select the customer account number and add a product code in itll show
the specific item as well as in another cell show the live price.
im not sure if this can be done with a simple formula or will have to go down the whole VBA route
i hope i have covered enough information. if you need anything else please let me know.
