We help IT Professionals succeed at work.
Get Started

old VBA script needs updated

Aaron Roessler
on
195 Views
Last Modified: 2020-02-13
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
Comment
Watch Question
Mechanical Engineer
CERTIFIED EXPERT
Distinguished Expert 2020
Commented:
This problem has been solved!
Unlock 1 Answer and 12 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant

An Experts Exchange subscription includes unlimited access to online courses.

Get Started
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE