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.
The VBA Module script is in the catalogPRICING.xls file