Excel Solution: Creating a simple GUI that will allow users to generate a continuous report (PDF) from the content of many worksheets.

Hi all,

I've done lots of searching but have been unable to find a solution, so I thought I'd post this small project to see if anyone is interested in attacking it.

In Excel, my overall goal is to create 1 continuous report (PDF) using many tables/charts from many different worksheets. The KEY is I want all the worksheet content (tables/charts), all from different worksheets, to be presented continuously (one table/chart after another & fitting as many as possible on each page).

There will be a GUI that gives users the option to either select 1) the DEFAULT ORDER of combining all worksheet content -or- 2) MANUALLY SELECTING/CHOOSING what sheets will be included in the report and how those sheets will be organized (i.e., what sheets are displayed 1st, 2nd, 3rd, etc). See an example of what this GUI could look like in the attached EXCEL file. I'm flexible on how this GUI actually looks like -- I just created a ugly example for demo purposes.

See attached PDF of what the report would look like based on what the user Choose/Selected. Note the organization of the sheet content (what is displayed 1st, 2nd, 3rd, 4th). Also note that what I attached is only for example purposes and not the actual Workbook.

My actual workbook will contain:

* ~10-15 worksheets

* each worksheet is very unique in terms of table formatting (merged cells, dimensions of cells, etc). I'd like to keep the formatting the same (as it is displayed in excel).

* different content (tables/charts) per worksheet and the combination of the content varies in size. Some sheets contain tables that are only 3-4 rows/columns, other sheets will have combined content (tables/charts) that take up 3/4ths of a page.

Finally, excel solution must work in Excel 2010 or greater.

Thank you.


Habilidades: Excel, Visual Basic para Apps

Ver mais: want create chart, create table chart, a solution, keep organized, hi charts, creating page, content report, visual content, key generate, find unique, excel small work, excel formatting, excel charts, create excel worksheet, continuous, gui small project, excel sheet formatting, report chart, visual basic excel post, charts excel, excel unique, sheet excel visual basic, 2013 excel visual basic, select pdf file, excel 2013 visual

Acerca do Empregador:
( 4 comentários ) Houston, United States

ID do Projeto: #5084907

4 freelancers estão ofertando em média $59 para este trabalho


Consider it done. Check my past reviews for your reference. Eagerly waiting for your reply so that i can start with the implementation.

$60 USD in 0 dias
(143 Comentários)

Hello, as per my understanding you want to print your Excel Sheet into PDF. you also want change Sheet Order using GUI. my solution will work in Excel 2010 or Greater. can we discuss about your Project ? Mais

$79 USD in 4 dias
(5 Comentários)

Hi, you will need a macro to generate the report with the custom selection. I'm prepared to write the macro and you won't have to pay unless I show you the satisfactory result. But you need to award the job so I can st Mais

$50 USD em 1 dia
(8 Comentários)

La propuesta todavía no ha sido proveída

$45 USD in 4 dias
(0 Comentários)