Hello... Can an yone help me please?
I have two excel files that laid out exactly the same.
The two files are: MB.xls and CT.xls.
I need to check each of the columns starting at C3 in the CT file with the column C3 in the MB file, if the rate if 5% less in the CT than in the MB (in C3 cell) then keep the C3 valuie in the CT table, ELSE, take the MB C3 rate - 5% and put that in the C3 of the CT table and change the color (since it was changed). The MB table is that master so that is why I cpmpare to that file and make changes in the CT table.
Can anyone help me with this... I know this has to be easy for someone that is verse in Excel, I am just not.
Thanks!!!
Bookmarks