Merge Multiple Files
Hi,
I am currently using Ron DeBruin's wonderful Merge Add-in to merge many
files. However, the data returns as one long extended row for each file. I
need it to return more grouped. For instance instead of
'FilepathName' Sales per hr. 25 28 30 26 24 Cards Applied 2 1 0
1 0 Hrs Worked 8 8 4 6 8
The above returns as one row I need
'FilepathName' Sales per hr 25 28 30 26 24
Cards Applied 2 1 0 1 0
hrs Worked 8 8 4 6 8
Of course there would be much more data gathered in my actual use.
I only have the Ron DeBruin Add-in not the code. I am not a VBA pro but
have copied and mopdified sufficiently so far.
Any other resources?
Thanks in advance,
Clint
|