Hey,
I'm trying to name three workbooks worth of data to the varaible that is in the first row of each column. The data deminsions can change, rows and in number of colums columns so I can't hardcode that.
I'm pretty new to Excel VBA so any help would be much appreciated. Data attached is an...