Need advice about dashboards

[riaarora]

Dear Experts,



I need your expert advice. I have an Access database which imports the data from different sources. After importing and processing the data I need to prepare the attached dashboard by Team (for 13 teams) which is in Excel. Each team has 2 to 10 bankers.

Data need to be exported into these Excel Dashboards from different tables. There are total 13 teams so 13 dashboards need to be prepared with different formatting.

This dashboard contains multiple tables and Graphs and all tables need to be formatted. I need your advice for the same. Which one out of below options is the best way to prepare this dashboard?

1. Use predefined template.
2. Directly export the data into excel dashboard in different table on particular range.
3. Any other option

Appreciate if someone can provide some sample code to export data in different tables of the dashboards and let me know how to refresh the graph in excel after exporting the data into excel.

Thanks a lot for all the help...

[June7]

Review http://forums.aspfree.com/microsoft-...el-413629.html

The graph 'refresh' should be automatic.

[riaarora]

Did not find anything which can produce dashboard like I have attached in Excel Format

[June7]

You want to export data from Access to the Excel workbook? The referenced thread shows example code for exporting data to specific cells of designated sheet in a workbook.

[riaarora]

It's taking lot of time. I need to populate this data in 15 same time sheets.

Is there any fast way to populate the data in attached sheet.

Please note we can't hard code the values in Column A as these contain Bankers names. And banker names will keep changing every month. These values need to be dynamic and as I said each team can have different number of bankers e.g.

Team 1
======
Banker ABC 1
Banker DEF 2
........
Banker HJK 38

Team 2
======
Banker PML 1
Banker DKS 2
......
Banker JOP 5

So we can not hard code these banker names. Every team will have different banker names and total number of bankers also will be different.

I hope this clarifies....

Please let me know some other solution. Really struggeling from last so many days to find the solution

[June7]

Where do you want the Banker names to come from? A table in db? Use code to open recordset and read the data from the recordset and save to Excel. I believe that is demonstrated in the example code.

[riaarora]

Hi

Banker's name will come from database only and these list of bankers will keep changing. These need to be dynamic.

I need to copy the data in each cell which is coming from different SQLs. Data need to be copied approx 1360 columns. And in this way I need to generate 15 Excel files.

Is there any best solution to do this?

Still wondering if anyone has done this type of project

[June7]

It will be a complex VBA procedure but can be done. The referenced examples give some indication of the method. If you don't have the programming skills might have to engage a professional consultant at about $50 to $100 an hour.

Why do you need the Excel component?