Create a Single Report from Multiple Worksheets in Excel 2010

[jb9445]

We need to use data from multiple worksheets to create a report in Excel 2010 that will print to a PDF file. In the past we've used Report Manager, however, it is a very old program and will not accommodate the amount of data included in this report.

Please help if you know how this can be achieved. Our report will be more than 100 pages.

[popipipo]

Without a xls file I (or we) can't help you

[jb9445]

I'm working with an Excel workbook in which one of the worksheets pulls data from another Excel file so the worksheet 20G-Report-wLY will state "Ref" in most instances. Since this is financial data, I cannot send the files it pulls from, however, I think that, if you click on the Add-Ins / Report Manager, you will see what we need. The report in Report Manager is 20G Report wLYBY.

I don't see how to send the file in ExcelForum.

[alansidman]

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[jb9445]

It said my file was too large.

[alansidman]

If your file is to big, then scale it down and give us only a representative sample. We don't need the whole file. Just enough records so we understand what you have, how it is formatted, etc. Additionally, you can always Zip your file to compress and make it smaller for uploading.