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):
![123477.jpg](/board/proxy.php?image=http%3A%2F%2Fwww.herber.de%2Fbbs%2Fuser%2F123477.jpg&hash=92712ba64a30ed7dbad86dcbda96dcba)
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:
![123478.jpg](/board/proxy.php?image=http%3A%2F%2Fwww.herber.de%2Fbbs%2Fuser%2F123478.jpg&hash=0075042020d4b5bd5e3f90da6445eb62)
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...
![Mad :mad: :mad:](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f621.png)
Iam wondering if somebody can help me with this.
Thanks in Advance
greetz
Ben