LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 38
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
merge multiple worksheets from multiple excel files into oneworksheet Shamoun Ilyas Excel Discussion (Misc queries) 5 November 19th 08 09:48 PM
How do I merge multiple xls files into one file? Steve Excel Discussion (Misc queries) 5 April 26th 07 08:28 PM
How do I merge multiple xls files into one file? Gianni Excel Discussion (Misc queries) 3 June 14th 05 02:09 PM
Merge multiple files into 1 Steph[_3_] Excel Programming 2 January 27th 05 10:49 PM
How can I merge multiple files using SQL? mb Excel Programming 1 February 17th 04 10:06 AM


All times are GMT +1. The time now is 06:34 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"