VBA clean data

[MrPowerQuery]

Hi there everyone!

i have to edit the following table.

It looks like this(see following first pic):

There are different sorts of labels in this table. I order to get best results i need to align under each other.
Like in my next picture:

After each Sort there should be a blank page/label. An the second or third rule is: For each sort there should be copied 2 more following them.

Actually i tried to record a macro and edit the VBA code to get best results. I also tried directly printing it with the macro but got some problems with the offset method getting in the next row after going right 2 times.

Man iam tired of this... Aint there any Excel-Bootcamp i could join?

Iam wondering if somebody can help me with this.


Thanks in Advance

greetz
Ben

 

[Fazza]

hi, Ben. For VBA - just start coding. You'll get better at it the more you code.

For the particular question. what defines the boundaries of each range/block?

regards, Fazza

 

[Peter_SSs]

Ben
Is this the same question as https://www.mrexcel.com/forum/questions-other-languages/1067858-daten-aufbereitung-cleanup.html

If so, I will close that other one per #12 of the Forum Rules as it seems you are fine with English and that other forum doesn't get a lot of traffic.

 

[MrPowerQuery]

hi Fazza,
will do!

hi, Ben. For VBA - just start coding. You'll get better at it the more you code.

For the particular question. what defines the boundaries of each range/block?

regards, Fazza

Really its just a Range("A1:K21") more precisely 11 cells on X-axis and 21 cells on Y-axis and theres an outter border around it.
In Cell A3 is some kind of a item number. Cant post the original table for data protection reasons.

lg
Ben

 

[MrPowerQuery]

Ben
Is this the same question as https://www.mrexcel.com/forum/questions-other-languages/1067858-daten-aufbereitung-cleanup.html

If so, I will close that other one per #12 of the Forum Rules as it seems you are fine with English and that other forum doesn't get a lot of traffic.

Hey Peter, it is. Maybe u can give it some time?? But ur the boss go on.
lg
Ben

 

[Fazza]

hi, Ben

I do not understand 100% & need further explanation.

I understand there are blocks of 21 rows x 11 columns. And three of these blocks across the worksheet.

The objective of these specific instructions are not clear to me "After each Sort there should be a blank page/label. An the second or third rule is: For each sort there should be copied 2 more following them."

I do not know how many of these (21 row blocks) are down the page.
Such as there are 3, or 30, or it needs to worked out by the code.
If the codes needs to work it out, what rules/logic are used?

When the code finishes, how many blocks are down the page?
So if before the code runs there are 3 blocks (each 21 rows x 11 columns) across & 3 blocks down, when the code finishes are there simply the same 9 blocks? Or are extra copies or blanks or something added?

Thank you, Fazza