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
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
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.
Our community of experts have been thoroughly vetted for their expertise and industry experience.
The Most Valuable Expert award recognizes technology experts who passionately share their knowledge with the community, demonstrate the core values of this platform, and go the extra mile in all aspects of their contributions. This award is based off of nominations by EE users and experts. Multiple MVEs may be awarded each year.
The Distinguished Expert awards are presented to the top veteran and rookie experts to earn the most points in the top 50 topics.