+ Reply to Thread
Results 1 to 2 of 2

Check In/Check Out by Item Number

  1. #1
    Registered User
    Join Date
    07-30-2020
    Location
    Charleston, SC
    MS-Off Ver
    Office 365
    Posts
    30

    Question Check In/Check Out by Item Number

    I have tried to approach this from a few different angles, but the formulas get really convoluted really quickly. I wanted to see if someone had a fresh idea that I could benefit from.
    Basically, we will have a bar-code scanner adding values into column A of sheet 2. I need sheet 1 to populate when an item number is added to sheet 2 such that, the first time that item number comes up, it fills out a new row on column A and the second time that item number comes up, it populates in the same row, column B. The item numbers cycle through and are reused on the same workbook, however, so I'll need a fresh row to populate when that same item number is entered a 3rd time, etc. There will be 240 rows of checking in and out per workbook and there's no guarantee to what order they will be scanned in/out. I'm hoping I presented this in a clear enough way to promote ideas. I appreciate any help you can provide!

  2. #2
    Forum Contributor
    Join Date
    11-28-2013
    Location
    KSA
    MS-Off Ver
    Office 2019 version 16.0.13130
    Posts
    901

    Re: Check In/Check Out by Item Number

    I think if you can look for inventory system template published, there is lot free, that can take some idea or template most match from you want and can post here to modify it

+ 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. Replies: 10
    Last Post: 07-22-2018, 04:00 PM
  2. [SOLVED] Check out and return - Check if entered item is already checked out
    By lostdesigns in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-25-2017, 10:05 AM
  3. How to check if excel file is Checked Out in SharePoing Check Out, run code, Check In
    By jrtraylor in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-08-2016, 04:36 PM
  4. [SOLVED] Need to check for an item number and retrieve certain information
    By jasondavie1992 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 09-30-2014, 11:40 AM
  5. Automatically check one or more check boxes when a parent check box is manually checked
    By Steverizer in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-17-2013, 09:43 PM
  6. [SOLVED] Menu Item check mark??
    By Derrick in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-01-2005, 02:06 PM
  7. Munu item with check box
    By Vetal in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-05-2005, 10:29 AM

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