troubleshooting Question

old VBA script needs updated

Avatar of Aaron Roessler
Aaron Roessler asked on
VBAPCMac OS X
15 Comments1 Solution213 ViewsLast Modified:
Back in 2006 I had a friend write me a VBA script that checks pricing and box quantity for my 160+ Excel catalog part# and pricing files. I have a Master List Price Sheet and the VBA script will use the Part# as unique identifier and compare pricing and box quantity to the Master List. it will also copy those rows from the Master List into the Excel sheet into the empty columns on the right in the Single Excel sheet. If the pricing is different it will highlight the copied text red in the Single Excel price sheet.

I created a video to help show and explain how it works.  
NOTE: I need the script to only "Find Entire Cells Only". I currently need to open the Find tool and select that before I run the script.
I also mentioned the Master Price sheet is 4,200 rows when its actually 42,000

PROBLEMS with Script:
1. Now that I am using Mac Excel 2019 v16.31 and not a PC computer,  the script is painfully slow. It was really fast on PC but on Mac takes long time for just one Excel doc thats only 300 rows long.

2. The script only makes the pricing text red if its different, I also need to highlight the box quantity text red if the box quantity is different.

VIDEO: https://www.loom.com/share/cdb5f27e684e44fdbb2cb3acb7165468

The VBA Module script is in the catalogPRICING.xls file
Autotrol-Parts-and-Accessories.xlscatalogPRICING.xls
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 15 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 15 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros