Ok- so have another tough one.
I have two workbooks, one is called Projections, one is report. Using VBA, I want to compare column A in Report with Column A in Projection. If they are the same then I want Column C from Projection to fill in Column G in Report. These are two different...