+ Reply to Thread
Results 1 to 4 of 4

associate a scanned item with a row of data and count the data in separate columns auto

  1. #1
    Registered User
    Join Date
    05-29-2018
    Location
    United States
    MS-Off Ver
    2016
    Posts
    2

    associate a scanned item with a row of data and count the data in separate columns auto

    I need help with my inventory tracking. I need to scan computers that have barcode tags on them. I have the scanner setup to scan and hit enter, so I can just fire away one after another. I have an excel spreadsheet that I export from a website that houses the data I need. This spreadsheet has data such as asset number, serial number, location and model. This data changes daily/weekly. I copy and paste this spreadsheet into my template I have and it helps with comparisons and counting. I reference the page and columns on this sheet other places to count the data currently.

    I want to be able to just scan the asset tag (sometimes alphanumeric) and have a count populate in multiple areas. For example. right now I scan the items in specific columns and then reference those columns in a COUNTA formula to count everything I scan in a particular column. I want to scan an item, lets say the asset tag is 123456, and for excel to know the model is TXZY computer and the location is Closet. Then I want it to automatically count on another page and column for Model and Location categories. So when I scan 123456, the count in Model TXYZ column and Closet column would be a 1. If I scan another asset with that information, then the count would go to 2 etc. If I scan, say 12347, and it is TXYZ model, but Lab location, then I want it to populate in the same way.

    My ultimate goal is this. Export spreadsheet of data from website. Paste/import into my excel template. Scan asset tags from any location and any particular models at my business and have them appropriately counted in different categories automatically. Please let me know your thoughts.
    Attached Files Attached Files
    Last edited by naydamua; 05-29-2018 at 01:19 PM. Reason: Mandatory Title Change

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider (Windows 10)
    Posts
    50,935

    Re: Inventory Tracking Made Easy

    Welcome to the forum! Please take a moment to re-read forum rule #1 and then amend your thread title to something that better explains your problem. Changing your thread title is not optional, which means you must change it. Thanks!

    • Use concise, accurate thread titles.
    • Your post title should describe your problem, not your anticipated solution.
    • Use terms appropriate to a Google search - poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice tell us nothing.
    • Responding to a request to change your thread title by doing so is mandatory.

    To change a title go to your first post, click EDIT then Go Advanced and change your title.

    No help to be offered, please, until the OP complies with this request.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

  3. #3
    Registered User
    Join Date
    05-29-2018
    Location
    United States
    MS-Off Ver
    2016
    Posts
    2

    Re: Inventory Tracking Made Easy

    Changed title, thank you for pointing this out. First time .

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider (Windows 10)
    Posts
    50,935

    Re: associate a scanned item with a row of data and count the data in separate columns aut

    That’s better - thanks.

+ 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. [SOLVED] Tracking Changes Made to VBA Code
    By EnigmaMatter in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-01-2014, 10:02 AM
  2. [SOLVED] surveying site records made easy
    By Trauts-Art in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-19-2013, 08:08 AM
  3. Tracking payments of one loan made by different people
    By danielcv in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-24-2012, 02:06 PM
  4. Excel to Google Earth made easy
    By rmpaternoster in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-07-2008, 08:05 AM
  5. inventory tracking
    By Tizwit in forum Excel General
    Replies: 3
    Last Post: 06-04-2008, 12:39 PM
  6. Dashboard made easy
    By arwin_pr in forum Excel General
    Replies: 4
    Last Post: 04-07-2008, 08:25 AM
  7. Two paste options I'd like to see made easy
    By t in forum Excel General
    Replies: 1
    Last Post: 08-22-2006, 06:30 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