Heve a look at Charley Kid's site
http://www.exceluser.com/

Ed Ferrero


"Hardip" wrote in message
...
Hi All

Are the any resources I can use to create a summary dashboard. I have
created individual reports that need to be aggregated and displayed for
management review.

I've concerned about the way to consolidate the data from each report into
a
staging area and then creating the necessary views. I know I'm capturing
all
the right details but don't want to set up the database (in excel)
incorrectly and then struggle.

I'd appreciate any pointer, guidance, online resources, add-ons, or paid
for
services to accelerate this process.

Thanks in advance to all who respond.

Cheers, H