How can sort this.

Hi to all, i'm new in excel and i'm in trouble.

it is posible with a macro turn this:

	a	b	c	f	d	v	g
a
b
c
f
d
c
f
v
b
g
g
g
f
f

into this:

	a	b	c	f	d	v	g
	a
		b
			c
				f
					d
			c
				f
						v
		b
							g
							g
							g
				f
				f

thanks in advance.
Xesc

Try this:-

Please Login or Register  to view this content.

Regards Mick

Hey guys, thank you very much for your answers and your speed. You are amazing. You made me gain valuable time.
Thank you very much again.
Have a great day
Xesc.

Hello again, I need a little modification on the macro.
It's possible that the macro "pass" over the cells that not match on the headers?
I mean, if a value on the first column not exists on the headers, now the macro "stops". It's possible that in this case simply continues with the rest of the list and leave this values on his own cell?
Thanks,
Xesc

Try this:-

Please Login or Register  to view this content.

Regards Mick

Hi MickG, you did it again
Thank you so much.
Xesc.

xesc, you're welcome

Marreco:- Below is the code with remarks, but the truth is, the code was a bit overkill and "dafodil11's" code was much simpler and better for it !!

Please Login or Register  to view this content.

Regards Mick