Hi Guys,
I currently have the following macro which works a treat however I wanted to add to it and Im not sure where to start.
Sub Consolidate()
'Open all Excel files in a specific folder and import data as separate sheets
'JBeaucaire (7/6/2009) (2007 compatible)
Dim strFileName As...