Hello,
I've received this question actually from my co-worker, but I did not manage to solve it myself.
The issue is rather simple, but I cannot manage to find the solution for it.
I have a single sheet with numbers on it, or amounts of trolleys and shelves as we call it in a table. Attached to these numbers are seperate pages to be printed on the same sheet, which shows each branch with the amounts from the table.
Some branches have 10 trolleys to be collected, some branches have no trolleys to be collected.
Right now, my co-worker prints out the sheet, and receives 64 pages, but we want this reduced, based on the numbers in the table, as we do not want to print the pages which show a 0 on the page.
I've tried to make a small vba code, based on the cell-value, so when this shows a zero, it should not print the range (of the page). This did not work at all.
So what I need is a VBA code that prints the pages where trolleys are to be collected.
If any value is more than zero on:
0 TAG5 Leeg
0 TAG5 Fust
0 TAG5 Kapot
then it should print the range of the page.
If you can make a code for one page, and I need to manually add each page to the code, that is also fine.
I hope this is clear for any of you guys and can help me sort this out!
Thanks,
Sam
Bookmarks