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
|