Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 50
Default Auton Populating Dashboard Spreadsheet

Good afternoon, i am trying to create a dashboard type report, so what i have
done is i create a dropdown menu of possible project into a cell. what i was
wondering how could this cell info allow the data related to that specific
project to be automatically uploaded into the spreadsheet.
If so can anyone send me an examlpe, i am sure its related to writing
macros, prob is i have not done so for many years so i am rusty....please
some help anyone..
Last thing can i also protect random cells and have them greyed out to
indicate that its read only?
I know its a lot but i would be greatful for any help...

Thanks a lot
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
KPI dashboard Julie Charts and Charting in Excel 2 January 4th 07 01:49 PM
Dashboard fkistner Excel Discussion (Misc queries) 2 March 31st 06 04:58 PM
Auto Populating cells from a master spreadsheet Steve K Excel Discussion (Misc queries) 0 July 1st 05 05:01 PM
dashboard John O. Knoke Charts and Charting in Excel 3 May 15th 05 05:26 AM


All times are GMT +1. The time now is 09:48 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"