J John Stubbings Jun 6, 2006 #1 I have about 100 xls files that I want to extract three columns from each and combine into one file. Any ideas?
I have about 100 xls files that I want to extract three columns from each and combine into one file. Any ideas?
C Chris Jun 6, 2006 #2 John Stubbings said: I have about 100 xls files that I want to extract three columns from each and combine into one file. Any ideas? Click to expand... The only way that I can think of is via VBA. Put all the files in a single folder and loop through each one copying the columns that you need.
John Stubbings said: I have about 100 xls files that I want to extract three columns from each and combine into one file. Any ideas? Click to expand... The only way that I can think of is via VBA. Put all the files in a single folder and loop through each one copying the columns that you need.
