Attached is a Zip file that contains 2 workbooks, one called Barcode Generator and one called Test Data. The Test Data is a report that is run daily that tells us what equipment was brought into inventory the day before. We copy this data and paste it into the Barcode Generator. The Generator looks at a bunch of different qualifiers and filters the equipment between the List (equipment that need a barcode sticker) and the Secondary List (equipment that should already have a barcode sticker).
This worked fine, but I recently got a new computer and now I'm having issues.Old computer: Windows 7, Excel 2010
New computer: Windows 10, Excel 2013
Issue: if I select Filter Data button to perform the macro (after I pasted the data from the Test Data workbook), it completely messes up the workbook (doesn't filter the data correctly, formatting on the List sheet is lost, and formatting on the Secondary Stickers sheet is lost). But, if I run the macro directly from Visual Basic, it works fine (Module 2, Filter_List macro).
Any idea what's going on?
Note: if you want to see the barcode on the Stickers sheets, you need to have the Code 128 font installed.
Thank-you in advance for any help!
Bookmarks