Hi Adam, Looking at your workbook, it seems that it's a complete dashboard project to be completed and in these cases Sample data wouldn't do the perfect job (However we can create one dummy dashboard).
I understand that you want it to be interactive to the user creating homepage and navigation with charts and other analysis. I have one question for you, why are you using images(charts) on the sheet. where as you can do it with excel charts itself. Your project is a big one and if we have to do it, it might take some time to go through all the sheets and understand the data structure to create an interactive data base. You will have to have patience for it. I understand that because of data confidentiality you cant share the complete data but in order to complete this dashboard or for giving a dashboard skeleton, we would expect one cleansed workbook only with the necessary sheets. Hope you understood what I am trying to say. Thanks, Anish On Wed, Jul 20, 2011 at 12:04 PM, Adam Hamilton <adamchamil...@gmail.com>wrote: > Hi, Guys, > > Thanks. You're recieving this error b/c I ommitted the resources > names for confidentiality. I'm looking for a macro, or complex > formulae that will allow the dashboard to be both interactive to the > user, as well as auto populate data, charts, stats, etc. > > On Tue, Jul 19, 2011 at 6:10 AM, Adam Hamilton <adamchamil...@gmail.com> > wrote: > > Hi, guys, > > > > So, I’ve created this complex budget workbook for the department I > > manage. Everything is automated, however, now that I want to create a > > dashboard with the data, all of my syntax are failing!!! > > > > I’ve spent endless hours on this, can someone PLEASE guide me in the > > right direction? As you can see from the sample db, the data I want > > to capture are all available in the Raw Data file. But after weeks of > > trying, I haven’t a clue, and am hard coding everything. > > > > PLEASE HELP > > > > > > -- > > > ---------------------------------------------------------------------------------- > > Some important links for excel users: > > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > > 3. Excel tutorials at http://www.excel-macros.blogspot.com > > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > > > To post to this group, send email to excel-macros@googlegroups.com > > > > <><><><><><><><><><><><><><><><><><><><><><> > > Like our page on facebook , Just follow below link > > http://www.facebook.com/discussexcel > > > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
