![]() |
Open two worksheets, then match and compare cells
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 |
All times are GMT +1. The time now is 10:19 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com