Recent content by Padraic

  1. Padraic

    Excel Changing amounts from one sheet to another using specific item #

    Unfortunately, I don't have time to learn a programing language. I'm trying to keep this as simple as possible so that way, if I'm out sick or on vacation, I can have someone handle this while I'm gone. It feels like I'm asking to reinvent the wheel here. And if I am, I'm sorry...
  2. Padraic

    Excel Changing amounts from one sheet to another using specific item #

    That would probably work, but I have to make sure that it's looking up the value that's associated with the Item #. If I just do that, it'll only work for the current line. I'm trying to make it update the quantity on hand when I create a Pick order.
  3. Padraic

    Excel Changing amounts from one sheet to another using specific item #

    Yes, something like that. I want to be able to put in a quantity on the pull page, and then have it change the available quantity automatically. As it is now, it's only displaying what's available no matter what. I'd have to go back and manually change the quantities, and when you're dealing...
  4. Padraic

    Excel Changing amounts from one sheet to another using specific item #

    Here's my problem. I'm trying to change the quantity (red box) that corresponds to the item number (blue box) after entering the requested amount (green box). How do I do this? It's an inventory management I'm trying to build. These are on two separate sheets. The 'Inventory List' (first...
Top