nitrobass24
New Member
- Joined
- Sep 23, 2009
- Messages
- 39
Don't know if this is possible, but here is what I would like to do.
Right now I have a 20 Analysis Workbooks that contain detailed analysis and have 10-20 worksheets in each.
I am going to create a "Dashboard Workbook" that pulls data in from all the analysis workbooks.There is a tab for each analysis workbook with charts that represent the data from each of the worksheets. So if Analysis Workbook(1) has 20 worksheets, inside my Dashboard Workbook, I have a worksheet named Analysis 1 that has 20 charts.
This will work fine when the workbooks are on my machine, but the problem is its not very portable/updates automatically when stored on SharePoint/email/etc.
My thought here is to embed all of the workbooks in a Word Doc, will this solve my problem?
Is there a better way around this?
Right now I have a 20 Analysis Workbooks that contain detailed analysis and have 10-20 worksheets in each.
I am going to create a "Dashboard Workbook" that pulls data in from all the analysis workbooks.There is a tab for each analysis workbook with charts that represent the data from each of the worksheets. So if Analysis Workbook(1) has 20 worksheets, inside my Dashboard Workbook, I have a worksheet named Analysis 1 that has 20 charts.
This will work fine when the workbooks are on my machine, but the problem is its not very portable/updates automatically when stored on SharePoint/email/etc.
My thought here is to embed all of the workbooks in a Word Doc, will this solve my problem?
Is there a better way around this?