Macro to compare multiple workbooks in two folders in Excel 2007

[plant007]

Good morning

I have had some really great support on this forum previously and I am keeping my fingers crossed that you may able to help me with the conundrum below. I am going to be taking a VBA course soon so hopefully I will be able to return the favour some day!

I collect data quarterly from multiple sources by sending out data collection forms (a workbook with 4 worksheets) pre-populated with the previous quarters data (so as to help sources fill in the forms).

I would like to be able to compare and highlight differences between the data sent out pre-populated and the data recieved back from the sources. Pre and post data file names (in this case, project names) will stay the same although they will be stored in two different folders (Q2 pre and Q2 post).

My aim is to compare across these two folders so that differences between the same-named files (although different dated workbooks) are highlighted in a new workbook, with each difference noted alongside the workbook/worksheet name

I am finding macros on the various sites that compare ranges in open workbooks or compare sheets but none that compares workbooks with the same name in different folders

Hope this explanation is clear but happy to provide additional information if the above does not make sense

Thanks in advance for any help
Andrew

 

[rbc1225]

WEre you able to come up with a solution to this?

 

[plant007]

Thankyou for asking and yes - an internal Excel / VBA whizz who we managed to grab for a couple of weeks sorted it

 

[rbc1225]

Thankyou for asking and yes - an internal Excel / VBA whizz who we managed to grab for a couple of weeks sorted it

I guess I should have followed with my first question. Can you share the solution or is something your work paid for?

 

[plant007]

It was a work solution but I can tell you we used VLOOKUP equations to compare data in the current set to data in the previous dataset

 

[rbc1225]

Ok sounds good, thanks for the reply. I actually got it figured out last night on a very limited basis so all is good.