+ Reply to Thread
Results 1 to 10 of 10

Inventory, barcodes, and hiding rows.

  1. #1
    Forum Contributor
    Join Date
    03-08-2011
    Location
    Lubbock, TX, USA
    MS-Off Ver
    Excel, Word, Outlook, OneNote 2013
    Posts
    141

    Inventory, barcodes, and hiding rows.

    I have an inventory spreadsheet with four columns.

    ITEM : AUTHORIZE : ON HAND : ISSUE : COMMENTS

    The scannable barcodes have been pasted into the comments column as images. There are currently 52 of them.

    What happens is that the ITEM queries a VLOOKUP table to get the ON HAND amount.

    AUTHORIZE is a static number that rarely changes. Once the ON HAND has been inserted it is subtracted from AUTHORIZE and the result is placed in the ISSUE column.

    The COMMENTS has a barcode image pasted onto the cell. The idea is when the parts are pulled from the warehouse they can be scanned out right there. Or a comment can be handwritten if needed.

    The problem:

    I would like to filter out all the rows with a zero in the ISSUE column. So, when I apply the filter the majority of the rows will hide. And, the majority of the barcodes hide with their respective row. But, somewhere near the end a few barcodes wont hide along with the rows and so will be in the wrong place. That kills the notion of only printing one page instead of thee to five pages.

    I've checked each images properties and all appear to have the same properties except size as some codes are longer or shorter. The failure to hide seems to happen in the last half a dozen or so parts, usually. So far there is only one that fails to hide no matter what. And I cannot find anything different about it.

    Thanks in advance.

    Phil

  2. #2
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Inventory, barcodes, and hiding rows.

    Does your barcode software force you to use images or can you have the output as text?

    A sample of your workbook would certainly be helpful.
    Here are directions:

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

  3. #3
    Forum Contributor
    Join Date
    03-08-2011
    Location
    Lubbock, TX, USA
    MS-Off Ver
    Excel, Word, Outlook, OneNote 2013
    Posts
    141

    Re: Inventory, barcodes, and hiding rows.

    I can do that. I just can't do that right away. A little later tonight I will modify the file and put it up. Thanks.

  4. #4
    Forum Contributor
    Join Date
    03-08-2011
    Location
    Lubbock, TX, USA
    MS-Off Ver
    Excel, Word, Outlook, OneNote 2013
    Posts
    141

    Re: Inventory, barcodes, and hiding rows.

    Quote Originally Posted by newdoverman View Post
    Does your barcode software force you to use images or can you have the output as text?

    A sample of your workbook would certainly be helpful.
    Here are directions:

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
    The inventory software generates barcodes as an image. You have a menu where you can print about 45 pages of barcodes. You cannot copy/paste them though. I used the snipping tool in win7 then pasted it to the cell.
    Attached Files Attached Files

  5. #5
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Inventory, barcodes, and hiding rows.

    What purpose does column E serve? You can't really do anything with the pictures of barcodes or any other picture. The data in each picture is the code under the barcode. Does your software allow you to extract that?

    Images don't work very well with filters.

  6. #6
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Inventory, barcodes, and hiding rows.

    If your barcode reader doesn't give you anything but images, then one of the software titles listed here could be of help.

    http://listoffreeware.com/list-of-best-free-barcode-scanner-software-for-windows/

  7. #7
    Forum Contributor
    Join Date
    03-08-2011
    Location
    Lubbock, TX, USA
    MS-Off Ver
    Excel, Word, Outlook, OneNote 2013
    Posts
    141

    Re: Inventory, barcodes, and hiding rows.

    Quote Originally Posted by newdoverman View Post
    What purpose does column E serve? You can't really do anything with the pictures of barcodes or any other picture. The data in each picture is the code under the barcode. Does your software allow you to extract that?
    Column E is Comments. On the hard copy if the item is Not In Stock I'll make a note there so they know the request wasn't overlooked. Or, the requester might have something special to add. As far as the spreadsheet is concerned the last column is merely where the image of the barcode is pasted. The idea being that we pull the item from stock and instead of looking up the item in a book we can immediately scan it. The ideal solution would be to find the specific barcode font and simply type in the part number. So far I am having no luck finding the specific barcode font.

    Quote Originally Posted by newdoverman View Post
    Images don't work very well with filters.
    LOL aint that the truth. Setting up the table to look up quantities was easy. Getting the math done was easy. But the picture is worth a thousand words. Cuss words that is.

    Quote Originally Posted by newdoverman View Post
    If your barcode reader doesn't give you anything but images, then one of the software titles listed here could be of help.

    http://listoffreeware.com/list-of-best-free-barcode-scanner-software-for-windows/
    I'll check that out. I appreciate the time you've taken. Thank you.

  8. #8
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Inventory, barcodes, and hiding rows.

    A Google search for Barcode fonts for Excel 2007 turned up a lot. Some were free while others weren't.

    Thank you for the feed back.

    Good luck with the project.

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

  9. #9
    Forum Contributor
    Join Date
    03-08-2011
    Location
    Lubbock, TX, USA
    MS-Off Ver
    Excel, Word, Outlook, OneNote 2013
    Posts
    141

    Re: Inventory, barcodes, and hiding rows.

    I discoverede that the images will stack with hidden ones under the unhidden. To do that you must ensure that all of the image is inside the cell borders. I resized and moved several images and it began to work much better.

    I also tried several barcode fonts. Apparently there is more to barcoding than I was aware of since none of them scanned. But, the freeware scanner in the above link at least helped me to identify the specific barcode iteration. Thank you for that. And, I do appreciate all the responses.

  10. #10
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Inventory, barcodes, and hiding rows.

    I have tested a couple of files that I have with images in a data table and all the images are well within the borders of the cells and even then using the filters on the data "can" mess up the images. So, be careful. The only thing that I have ever used that handled data and images properly was a database.

    Good luck.

+ 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: 0
    Last Post: 05-24-2013, 02:06 PM
  2. Inventory counting by comparing stock barcodes against master barcodes list
    By jamiemacdonough in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-23-2011, 04:51 PM
  3. Hiding a button when hiding rows
    By fergusor in forum Excel General
    Replies: 2
    Last Post: 08-10-2006, 09:31 AM
  4. Hiding a button when hiding rows
    By richard_m_ferguson@hotmail.com in forum Excel General
    Replies: 4
    Last Post: 08-09-2006, 02:19 PM
  5. [SOLVED] Hiding column/row labels --without hiding entire columns/rows
    By daniel.wolff@csfb.com in forum Excel General
    Replies: 2
    Last Post: 10-18-2005, 10:05 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