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
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