Copy rows to new excel book with different sheets

[jvlavl]

Hello,

I need to copy rows with different letters to separated sheets in a new excel file.
Example

[TABLE="width: 500"]
<tbody>[TR]
[TD]a[/TD]
[TD]45[/TD]
[TD]46[/TD]
[TD]c[/TD]
[/TR]
[TR]
[TD]r[/TD]
[TD]44[/TD]
[TD]12[/TD]
[TD]d[/TD]
[/TR]
[TR]
[TD]v[/TD]
[TD]55[/TD]
[TD]33[/TD]
[TD]e[/TD]
[/TR]
[TR]
[TD]v[/TD]
[TD]44[/TD]
[TD]22[/TD]
[TD]c[/TD]
[/TR]
[TR]
[TD]g[/TD]
[TD]22[/TD]
[TD]11[/TD]
[TD]f[/TD]
[/TR]
[TR]
[TD]f[/TD]
[TD]44[/TD]
[TD]33[/TD]
[TD]d[/TD]
[/TR]
[TR]
[TD]g[/TD]
[TD]88[/TD]
[TD]77[/TD]
[TD]e[/TD]
[/TR]
</tbody>[/TABLE]

all rows ending with c need to be placed in a new workbook on a sheet rows ending with d or any letter need to be placed on a different sheet only having that letter.

How can I do that

Rgds,

John

 

[AFPathfinder]

I'd say sort column D and manually copy/paste, but I'm assuming you'll need to do this more than once, right? How familiar are you with VBA?

 

[jvlavl]

Hello,

I completly new to VBA.
Yes, I need to do it daily

Can you help?

 

[AFPathfinder]

Besides "c" each other letter has it's own sheet, right? For example, rows with an "a" need to go to a sheet named "a"; rows with a "b" need to go to a sheet named "b". Do these sheets already exist? Is "c" the only value in column D that doesn't follow this convention?