Copy and fill cells with existing numbers

[Vestlink]

Hi.

I have a structure like this that i want to convert to.

Included is an 2007 excel file.

How would that be done.

Best regards,

Nicolai

[bonny24tycoon]

Hi Vestlink,

It would be great if you could attach an example spreadsheet.



If I was able to help – PLEASE DO NOT FORGET to Click the small star icon at the bottom left of my post.

[johncena]

try
http://www.techrepublic.com/blog/mso...-in-excel/3014

[Vestlink]

tnx

seams to work when not using a macro :-)

But I'd like to have a macro do like in the enclosed example. how would that be done?

Nicolai