Looping through rows and put values in another sheet

[Bilberry]

Hi All,
I have tried a couple of hours but i coulnt get realised it. I have a table with the following records:

€ 692,51
1a -€ 249,17
1b -€ 377,36
sub 1a -€ 39,74
sub 1b -€ 26,24
(empty)

The content may change. E.g it is also possible to have the values:

€ 692,51
1b -€ 377,36
3c -€ 300,55
sub 1b -€ 39,74
sub 3c -€ 39,74
(empty)



I want to put these values in another report. The values of 1a, 1b, and 1c etc should be copied to the B column and the sub 1a, sub 1b etc should be copied to the C column. The A Column (the values are fixed) start as follows:

1a blablablabla
1b blablablabla
1c balbalablabla

2a blablabla
2b blablabla
2c blablabal

3a blabla bla
3b blabalba
3c blabla

So based on my first example i want to get the following result:

1a blablablabla -€ 249,17 -€ 39,74
1b blablablabla -€ 377,36 -€ 26,24
1c balbalablabla

2a blablabla
2b blablabla
2c blablabal

3a blabla bla
3b blabalba
3c blabla

and based on the second example i want to get:

1a blablablabla
1b blablablabla -€ 377,36 -€ 39,74
1c balbalablabla

2a blablabla
2b blablabla
2c blablabal

3a blabla bla
3b blabalba
3c blabla -€ 300,55 -€ 39,74

Does anybody have idea's how i can realize this? A Star for the golden solution...

 

[SkipVought]

Hi,

What have you tried and what was the result?

You code please.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}