Announcement

Collapse
No announcement yet.

$20 USD: VBA- Add additional ComboBox and populate the information in another Column

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • $20 USD: VBA- Add additional ComboBox and populate the information in another Column

    Hi Guys,

    I am trying to add additional information to my Inventory report. This time I want to sort products by location numbers example A2, A9 and so forth. In order to do this I want to add another ComboBox with multiple option, select from here Locations numbers like A1,A8 etc and show this information in another column. Further information can be found in the attached spreadsheet.

    Note some of the code is in Spanish.

    Attached Files

  • Fabian76
    replied
    Hi Trunten,

    Fortunately I got an answer.

    Thanks for you reply.

    Leave a comment:


  • KjBox
    replied
    Your file is ready, I will PM you with my PayPal details.

    Leave a comment:


  • KjBox
    replied
    So sorry, there has not been any internet connection here for the last 2 days, I have not even been able to retrieve your file from my cloud storage!

    Internet just came back and I will get your file finished very soon.

    Leave a comment:


  • trunten
    replied
    I can give it a shot if you like. Not sure how the Spanish issue will affect things though. Iíll have a look and get back to you

    Leave a comment:


  • Fabian76
    replied
    Hi guys,

    Unfortunately I have not received a solution yet. Is there anyone else interested on this small project? I already paid to Ozgrid

    Leave a comment:


  • Fabian76
    replied
    Sorry for my late response. I did.

    Leave a comment:


  • KjBox
    replied
    Did you get my private message?

    Leave a comment:


  • Fabian76
    replied
    Thank you!

    Leave a comment:


  • KjBox
    replied
    Kimbo is not entitled to answer questions in the Hire Help forum.

    I will get a solution for you by Monday AM

    Leave a comment:


  • Fabian76
    replied
    Hi Kilmbo, I did. Are you able to help?

    Leave a comment:


  • Fabian76
    replied
    Hi KJ-

    My answers below:
    What happens if a user needs to sell 300 pieces of an item but there is insufficient quantity in any one location? For instance if A1 has 200 and B2 has 250. Ideally the user should not be allowed to do it and pop up a message telling him "please take XXXX from another location"

    Also, will a purchase go to just one location or can a single purchase be split between multiple locations? It can be split between multiple locations.

    Thanks

    Leave a comment:


  • KjBox
    replied
    Also, will a purchase go to just one location or can a single purchase be split between multiple locations?

    Leave a comment:


  • KjBox
    replied
    OK, thanks Alan.

    @Fabian

    What happens if a user needs to sell 300 pieces of an item but there is insufficient quantity in any one location? For instance if A1 has 200 and B2 has 250.

    Leave a comment:


  • AlanSidman
    replied
    @KJ--Go for it!

    Leave a comment:

Working...
X