Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
merge multiple worksheets from multiple excel files into oneworksheet | Excel Discussion (Misc queries) | |||
How do I merge multiple xls files into one file? | Excel Discussion (Misc queries) | |||
How do I merge multiple xls files into one file? | Excel Discussion (Misc queries) | |||
Merge multiple files into 1 | Excel Programming | |||
How can I merge multiple files using SQL? | Excel Programming |