+ Reply to Thread
Results 1 to 4 of 4

Inventory tracker

  1. #1
    Forum Contributor
    Join Date
    08-22-2009
    Location
    Manitoba
    MS-Off Ver
    Office 2010
    Posts
    524

    Inventory tracker

    I am trying to make this simple inventory tracker, but it's been a while since I did any VBA and my mind is drawing a blank! I am hoping someone out there can give me a little kick start and then I can finish my project. I have attached a simple worksheet, where on the calc sheet shows I selected item "B" and a quantity of 3 items will be used. When I print this with an active-x button to pdf, I want this value to be reduced on the inventory worksheet. Where I am perplexed is how does it find the correct item in the list? I am thinking maybe vlookup? Thanks for any help provided!
    Attached Files Attached Files

  2. #2
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MO Prof Plus 2016
    Posts
    6,907

    Re: Inventory tracker

    One way.
    Please Login or Register  to view this content.
    Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
    You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.

  3. #3
    Forum Contributor
    Join Date
    08-22-2009
    Location
    Manitoba
    MS-Off Ver
    Office 2010
    Posts
    524

    Re: Inventory tracker

    Fantastic bakerman2! Works like I was hoping and now I can build from that. Thanks!!

  4. #4
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MO Prof Plus 2016
    Posts
    6,907

    Re: Inventory tracker

    You're welcome and thanks for adding rep points.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Help build a Leave tracker and Effort Time Estimation Tracker
    By cherias in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-29-2015, 02:10 PM
  2. System idle time tracker / Break Tracker
    By reetika05 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-10-2014, 07:26 AM
  3. [SOLVED] Need remaining average inventory price after partial inventory is sold
    By Akano in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-04-2012, 04:12 AM
  4. Excel 2007 : Inventory Tracker
    By criticaleye in forum Excel General
    Replies: 0
    Last Post: 09-22-2011, 01:31 PM
  5. Inventory Tracker Question
    By shmew22 in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 12-06-2010, 01:11 PM
  6. updatable inventory tracker
    By ivander8 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-31-2009, 01:48 PM
  7. time tracker-a running tracker date wise
    By arnab0711 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-18-2008, 03:08 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1