MrPowerQuery
New Member
- Joined
- Aug 7, 2018
- Messages
- 11
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
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