+ Reply to Thread
Results 1 to 9 of 9

Is Excel able to recognize ID numbers for tracking inventory?

  1. 10-23-2018, 09:32 AM #1
    mogrinpas
    mogrinpas is offline
    Registered User
    Join Date
    10-18-2018
    Location
    Meadville, PA
    MS-Off Ver
    2010
    Posts
    5

    Is Excel able to recognize ID numbers for tracking inventory?

    Good morning all who are reading this. I am trying to create a program through Excel 2010 that will keep and maintain inventory for the waste water treatment plant that I work for.

    Before I really begin making this software, I suppose I need to know if Excel is "smart enough", to recognize ID numbers for equipment. For example, if I fill out an equipment used form and punch in "equipment ID- 123, amount used- 2", is there a formula for Excel to automatically deduct that number from my inventory list?

    I hope I am explaining this alright. I will attatch a photo of my example.EXAMPLE 1.pngEXAMPLE 2.png
    Reply With QuoteRegister To Reply
  2. 10-23-2018, 09:35 AM #2
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,647

    Re: Is Excel able to recognize ID numbers for tracking inventory?

    I suppose the pertinent question is how good is your VBA programming?

    The simple answer is "yes" - Excel is smart enough, certainly, but it's unlikely to be entirely doable using just formulae.

    Hope this answers your question.
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  3. 10-23-2018, 09:37 AM #3
    CK76
    CK76 is offline
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,883

    Re: Is Excel able to recognize ID numbers for tracking inventory?

    While it is possible to create inventory system in Excel. I wouldn't recommend it.

    As time goes on, you will find yourself spending more and more time on maintenance of workbook, negating benefit of tracking mechanism.

    Excel's strength is in it's flexibility and analysis tools, not in data management and integrity.

    I'd recommend investing time and/or money on database (MS Access does a good job, or you can go with more robust multi-user system based on MySQL or MSSQL).

    See link for fairly good tutorial on creating Stock Control database.
    http://www.software-matters.co.uk/cr...-database.html
    ?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
    ― Robert A. Heinlein
    Reply With QuoteRegister To Reply
  4. 10-23-2018, 10:20 AM #4
    mogrinpas
    mogrinpas is offline
    Registered User
    Join Date
    10-18-2018
    Location
    Meadville, PA
    MS-Off Ver
    2010
    Posts
    5

    Re: Is Excel able to recognize ID numbers for tracking inventory?

    Thank you for your responses. I will evaluate my options before I proceed.
    Reply With QuoteRegister To Reply
  5. 10-23-2018, 10:44 AM #5
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,647

    Re: Is Excel able to recognize ID numbers for tracking inventory?

    I agree with CK76, by the way, that Excel is not really the most appropriate tool for the job.
    Reply With QuoteRegister To Reply
  6. 10-23-2018, 11:30 AM #6
    mogrinpas
    mogrinpas is offline
    Registered User
    Join Date
    10-18-2018
    Location
    Meadville, PA
    MS-Off Ver
    2010
    Posts
    5

    Re: Is Excel able to recognize ID numbers for tracking inventory?

    Do either of you have any recommendations on tools I can use to design the software in question?
    Reply With QuoteRegister To Reply
  7. 10-23-2018, 11:40 AM #7
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,647

    Re: Is Excel able to recognize ID numbers for tracking inventory?

    CK76 already did that in his last post. MS Access would be OK - there are lost of templates, and as far as I am aware, you can create a multi-user system with it. Do you know anything about SQL coding?
    Reply With QuoteRegister To Reply
  8. 10-23-2018, 12:33 PM #8
    mogrinpas
    mogrinpas is offline
    Registered User
    Join Date
    10-18-2018
    Location
    Meadville, PA
    MS-Off Ver
    2010
    Posts
    5

    Re: Is Excel able to recognize ID numbers for tracking inventory?

    A bit, yes
    Reply With QuoteRegister To Reply
  9. 10-23-2018, 12:54 PM #9
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,647

    Re: Is Excel able to recognize ID numbers for tracking inventory?

    Did you follow the link provided?
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Excel not recognize numbers
    By cadineshkumar in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 06-29-2018, 04:08 AM
  2. Extracting and recognize various characters from cells - Inventory issue
    By EJSPIZZA in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-04-2014, 01:53 PM
  3. Trying to get excel to recognize data as numbers
    By jlax34 in forum Excel General
    Replies: 2
    Last Post: 09-25-2013, 05:04 PM
  4. How to create inventory, cost and profit tracking system using excel
    By Stella2012 in forum Excel General
    Replies: 1
    Last Post: 08-15-2012, 05:38 PM
  5. Inventory Tracking - Excel or Access
    By OtterBoxing in forum Excel General
    Replies: 2
    Last Post: 06-23-2012, 03:30 PM
  6. Inventory Tracking - Inserting a range of numbers
    By alana.maulder in forum Excel General
    Replies: 0
    Last Post: 04-07-2011, 12:15 AM
  7. Inventory Spreadsheet needs recognize certain values and adjust accordingly
    By DKS in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 01-20-2011, 09:00 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1