Open two worksheets, then match and compare cells

B

Bob

Hello,
I know a little VBA but I'm hoping for the experts here to help me
solve this problem.

I need to open two different worksheets, of different size, match cells
in column 1 (text), once done, I need to match cells in column 2
(text), then match cells in column 3, and then compare dates in columns
4 and 5. If the dates don't match the dates in the same columns of the
second file, it needs to change font or highlight the cell.

This is comparing two MS Project Excel Export files that's done once
per week. It's needs to check whether dependencies is moving start or
finish dates.

Col.1 Col.2 Col.3 Col.4 Col.5
Group Project Task Start Date Finish Date

APU K1234 Requirements xx/xx/xx xx/xx/xx
APU K1234 Design xx/xx/xx xx/xx/xx
HYD K2345 Requirements " "
etc.
etc.
etc.

...........

Any help would be greatly appreciated. Thanks in advance.
Bob
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top