Excel UPC Barcode Macros

I have an existing workbook filled with raw, internally-maintained data. Each time I need to distribute product information I spend far too long copying, filtering and formatting that sheet into a clean file that shows every item’s UPC barcode. I’d like you to build a set of VBA macros that turns this into a push-button task.

Here’s what I need the code to do:

• Pull the relevant columns from my main data sheet (Order Number with specific filters).
• Create a new worksheet or standalone file that keeps only those fields and converts the UPC column into scannable barcodes. If you prefer to call a barcode font (that is what we do), that’s fine; if you’d rather draw the barcode with code, that works too—as long as the result scans reliably.
• Apply consistent, professional formatting so the finished report is presentation-ready the moment it’s generated.
• Leave me with clear buttons or shortcuts so any non-technical colleague can repeat the process without touching the code.

Everything the macro uses will live in the same workbook; no external databases or APIs are involved. Please comment your VBA thoroughly so I can tweak fields or formatting later, and include brief usage instructions inside the file. I’m ready to start as soon as you can confirm your approach and timeline.