Hello,
I have been searching the web forever to find a solution to my problem but have failed
I'm not very knowledgeable of VBA so I can't write anything on my own.
My issue is that I have multiple reports in 1 worksheet. Each report is separated with a page break but some of these reports print out on multiple pages if too many rows are generated from the report engine. I am using a program called nVision to generate these reports and for various reasons, I need to consolidate multiple reports into a single worksheet.
Ideally, I would like to have each page scaled to fit in landscape. A 2nd option is to have a macro run so that the reports will be copied into a separate worksheet at every page break that I've inserted. Each worksheet needs to be named after the value that appears in column B, 2nd row after the page break. The new worksheets need to be scaled to fit.
Any help would be greatly appreciated. This report has haunted my office for years and this page break is my last hurdle.
I have been searching the web forever to find a solution to my problem but have failed
I'm not very knowledgeable of VBA so I can't write anything on my own.My issue is that I have multiple reports in 1 worksheet. Each report is separated with a page break but some of these reports print out on multiple pages if too many rows are generated from the report engine. I am using a program called nVision to generate these reports and for various reasons, I need to consolidate multiple reports into a single worksheet.
Ideally, I would like to have each page scaled to fit in landscape. A 2nd option is to have a macro run so that the reports will be copied into a separate worksheet at every page break that I've inserted. Each worksheet needs to be named after the value that appears in column B, 2nd row after the page break. The new worksheets need to be scaled to fit.
Any help would be greatly appreciated. This report has haunted my office for years and this page break is my last hurdle.
