+ Reply to Thread
Results 1 to 2 of 2

Inventory Tracker Sheet Help

  1. #1
    Registered User
    Join Date
    11-20-2019
    Location
    Alberta, Canada
    MS-Off Ver
    Latest
    Posts
    1

    Inventory Tracker Sheet Help

    Hey there,
    New to the forum, still trying to fumble my war around Excel as well.

    I'm currently using Excel and the app & excel add-in (SCAN-IT to office).
    Currently with the phone app, I can first select whether the barcode scan will add or subtract (-1 or 1). I then scan the barcode, and whichever cell is selected in Excel will received the numeric barcode, and the cell to it's right will receive the value or -1 or 1. I'd like to have this cell add or subtract from our current inventory. Is this possible? If so how.
    Maybe I'm using the wrong barcode scanner app too.
    Please see sheet attached. For privacy i changed all products and reference #'s to placeholders. but this is EXACTLY how the sheet will look in order.
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    06-05-2017
    Location
    Brazil
    MS-Off Ver
    365
    Posts
    650

    Re: Inventory Tracker Sheet Help

    Welcome to the forum!
    Not sure I understand what you are trying to accomplish.
    What is the expected result and in what column/row is it to be calculated?

+ 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. Inventory Tracker Help
    By SethE0531 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-10-2019, 04:12 AM
  2. Excel/Google sheets order, delivery and inventory tracker
    By jackesnacke in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 12-05-2017, 04:27 PM
  3. Inventory tracker
    By thecdnmole in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-04-2016, 08:30 PM
  4. [SOLVED] Need Help with Inventory Sheet: Adding to the inventory and Logging
    By petg in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-09-2015, 02:26 PM
  5. Excel 2007 : Inventory Tracker
    By criticaleye in forum Excel General
    Replies: 0
    Last Post: 09-22-2011, 01:31 PM
  6. Inventory Tracker Question
    By shmew22 in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 12-06-2010, 01:11 PM
  7. updatable inventory tracker
    By ivander8 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-31-2009, 01:48 PM

Tags for this Thread

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