Excel Guru Needed - Help with order form that will update an inventory


  1. Posts : 2,177
    Windows 8.1 Pro x64
       #1

    Excel Guru Needed - Help with order form that will update an inventory


    Hi,

    I was hoping someone could help me with creating an order form in excel that would then update the inventory (the main reason for this is to update the inventory rather than actually store any data).

    e.g.
    Order for Black Collar with the name jamie - when clicking on proceed it would update the inventory minus 1 black strap and letter J, A, M, I, E

    The inventory would consists of Collars, Letter and Charms.
    This is where i am having real difficulty and can't figure it out as the order could be for different collar style or colors, there are 2 different letter styles (silver and colored) so the order form would need to know what set of letters to update the quantity against...

    I have attached the actual excel sheet i was going to use so you can see exactly what i have got so far but it is almost an empty shell at the moment as i got stuck with this order form/updating inventory part.

    As you will see when you open the excel sheet, i would like to be able use the 'Order Form' button to process the order that would then minus the QTY against the inventory.

    When you click the 'Inventory' button there are 3 sections (Collars, Letters, Charms) this is where i would like the numbers to update from the 'Order Form'

    I hope someone is able to help, i know its a lot to ask.

    I have put description examples on the order form to try and help you understand what i am trying to achieve.

    Regards,
    Jamie
    Excel Guru Needed - Help with order form that will update an inventory Attached Files
      My Computer


  2. Posts : 12,012
    Windows 7 Home Premium SP1, 64-bit
       #2

    It's over my head, but you might have some luck at the MrExcel forum.
      My Computer


  3. Posts : 2,177
    Windows 8.1 Pro x64
    Thread Starter
       #3

    ignatzatsonic said:
    It's over my head, but you might have some luck at the MrExcel forum.
    Cheers for the reply, i will look at posting there a little later in the month if i dont get any replies here or the other excel forum i have posted in (Help with order form that will update an inventory) although i haven't had anything back from them yet... /Fingers Crossed

    Don't want to post it in too many places at the same time

    Cheers.
      My Computer


  4. Posts : 1,030
    Linux Mint / XP / Win7 Home, Pro, Ultimate / Win8.1 / Win10
       #4

    Hello Jamie -

    I'll play around with it but I think you would be better served using Access.

    Regards,
    GEWB
      My Computer


  5. Posts : 1,030
    Linux Mint / XP / Win7 Home, Pro, Ultimate / Win8.1 / Win10
       #5

    Have you tried a DuckDuckGo or Google search? See if these terms yield anything:

    • excel inventory sales spreadsheet
    • excel inventory order spreadsheet

    Regards,
    GEWB
      My Computer


  6. Posts : 2,177
    Windows 8.1 Pro x64
    Thread Starter
       #6

    GEWB said:
    Have you tried a DuckDuckGo or Google search? See if these terms yield anything:

    • excel inventory sales spreadsheet
    • excel inventory order spreadsheet

    Regards,
    GEWB
    Sorry for the very slow reply and thank you for your help.

    I have done a lot of searches and not come up with anything (the order form part), i think you are right with using access although i am going to have a go at setting Oracle APEX up to do the job

    Regards,
    JDobbsy1987
      My Computer


 

  Related Discussions
Our Sites
Site Links
About Us
Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

© Designer Media Ltd
All times are GMT -5. The time now is 01:18.
Find Us