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

Hi Whois

No the add-in not have this option
But I want to create a code example for you if you want to try this

Give me the ranges and I reply this evening with a example


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Whois Clinton" wrote in message ...
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

WOW direct from the master himself. ok
I use your merge add-in for almost all of my queries. So here is one sample
of me trying compile ranges differently.

The Range is B4:D34 So I would want results showing the filnename, then I
reference cell B1 for the Staff Name. Column B:4 then next row Column C4:C34
and next row D4:D34. It is multiple data based on dates of the month so
that is why it would be better clumped together this way rather than the one
long row.

In seperate queries I have tried to gather info from more than one sheet i n
several files from multiple folders. Right now I run your Merge 3 times to
get info from 3 different sheets. Then LOTS of copying and pasting to
reformat. Can your Merge Add-in include ioptions for more than one sheet.
Using the "Merge All Sheets" option would be way to much and they share no
common name. They are named by months.


Thanks so much for any and all help. yur work has saved me weeks of copy
and pasting work already I greatly appreciate it.

Clint

"Ron de Bruin" wrote:

Hi Whois

No the add-in not have this option
But I want to create a code example for you if you want to try this

Give me the ranges and I reply this evening with a example


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Whois Clinton" wrote in message ...
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

Hi Clint

I try to do it today but maybe it will be tomorrow
Send me one of the files private, easier to see for me then and test the code

Can your Merge Add-in include ioptions for more than one sheet.
You have a filter option now in the add-in for sheet names that start with contains or ends with ????

In the next version I will add a option to fill in more then one sheet name




--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Whois Clinton" wrote in message ...
WOW direct from the master himself. ok
I use your merge add-in for almost all of my queries. So here is one sample
of me trying compile ranges differently.

The Range is B4:D34 So I would want results showing the filnename, then I
reference cell B1 for the Staff Name. Column B:4 then next row Column C4:C34
and next row D4:D34. It is multiple data based on dates of the month so
that is why it would be better clumped together this way rather than the one
long row.

In seperate queries I have tried to gather info from more than one sheet i n
several files from multiple folders. Right now I run your Merge 3 times to
get info from 3 different sheets. Then LOTS of copying and pasting to
reformat. Can your Merge Add-in include ioptions for more than one sheet.
Using the "Merge All Sheets" option would be way to much and they share no
common name. They are named by months.


Thanks so much for any and all help. yur work has saved me weeks of copy
and pasting work already I greatly appreciate it.

Clint

"Ron de Bruin" wrote:

Hi Whois

No the add-in not have this option
But I want to create a code example for you if you want to try this

Give me the ranges and I reply this evening with a example


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Whois Clinton" wrote in message
...
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

Ok, how do I send in private?
and thanks
Clint

"Ron de Bruin" wrote:

Hi Clint

I try to do it today but maybe it will be tomorrow
Send me one of the files private, easier to see for me then and test the code

Can your Merge Add-in include ioptions for more than one sheet.
You have a filter option now in the add-in for sheet names that start with contains or ends with ????

In the next version I will add a option to fill in more then one sheet name




--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Whois Clinton" wrote in message ...
WOW direct from the master himself. ok
I use your merge add-in for almost all of my queries. So here is one sample
of me trying compile ranges differently.

The Range is B4:D34 So I would want results showing the filnename, then I
reference cell B1 for the Staff Name. Column B:4 then next row Column C4:C34
and next row D4:D34. It is multiple data based on dates of the month so
that is why it would be better clumped together this way rather than the one
long row.

In seperate queries I have tried to gather info from more than one sheet i n
several files from multiple folders. Right now I run your Merge 3 times to
get info from 3 different sheets. Then LOTS of copying and pasting to
reformat. Can your Merge Add-in include ioptions for more than one sheet.
Using the "Merge All Sheets" option would be way to much and they share no
common name. They are named by months.


Thanks so much for any and all help. yur work has saved me weeks of copy
and pasting work already I greatly appreciate it.

Clint

"Ron de Bruin" wrote:

Hi Whois

No the add-in not have this option
But I want to create a code example for you if you want to try this

Give me the ranges and I reply this evening with a example


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Whois Clinton" wrote in message
...
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

See the mail address on this page
http://www.rondebruin.nl/

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Whois Clinton" wrote in message ...
Ok, how do I send in private?
and thanks
Clint

"Ron de Bruin" wrote:

Hi Clint

I try to do it today but maybe it will be tomorrow
Send me one of the files private, easier to see for me then and test the code

Can your Merge Add-in include ioptions for more than one sheet.
You have a filter option now in the add-in for sheet names that start with contains or ends with ????

In the next version I will add a option to fill in more then one sheet name




--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Whois Clinton" wrote in message
...
WOW direct from the master himself. ok
I use your merge add-in for almost all of my queries. So here is one sample
of me trying compile ranges differently.

The Range is B4:D34 So I would want results showing the filnename, then I
reference cell B1 for the Staff Name. Column B:4 then next row Column C4:C34
and next row D4:D34. It is multiple data based on dates of the month so
that is why it would be better clumped together this way rather than the one
long row.

In seperate queries I have tried to gather info from more than one sheet i n
several files from multiple folders. Right now I run your Merge 3 times to
get info from 3 different sheets. Then LOTS of copying and pasting to
reformat. Can your Merge Add-in include ioptions for more than one sheet.
Using the "Merge All Sheets" option would be way to much and they share no
common name. They are named by months.


Thanks so much for any and all help. yur work has saved me weeks of copy
and pasting work already I greatly appreciate it.

Clint

"Ron de Bruin" wrote:

Hi Whois

No the add-in not have this option
But I want to create a code example for you if you want to try this

Give me the ranges and I reply this evening with a example


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Whois Clinton" wrote in message
...
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

Dear Ron De Burin

I have also downloaded this Add-In and need the same solution please

Adnan

"Ron de Bruin" wrote:

Hi Whois

No the add-in not have this option
But I want to create a code example for you if you want to try this

Give me the ranges and I reply this evening with a example


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Whois Clinton" wrote in message ...
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