Hi,
I have a series of excel files in a folder that have the same Sheet1 format (column for date, ID, names etc) and I'd merge them into one long Sheet1 file instead. Additionally, I'd like to add an extra column with the file name from which each data value originated from, this way I can keep a track of which data is from which file originally. How is this possible? Any help would be appreciated, I'm fairly VBA incompetent. :S
I have a series of excel files in a folder that have the same Sheet1 format (column for date, ID, names etc) and I'd merge them into one long Sheet1 file instead. Additionally, I'd like to add an extra column with the file name from which each data value originated from, this way I can keep a track of which data is from which file originally. How is this possible? Any help would be appreciated, I'm fairly VBA incompetent. :S
