Hello,
I'm currently working on a project where I have the following dashboard spreadsheet:
- List of 10 names
- Each name has 10 "Task Codes" which correspond to them. Some Task Codes between people are similar, others are not.
- Each "Task Code" has "Actual" and "Planned" hours Data.
- There "Actual" and "Planned" data for 10 "periods"
- A spreadsheet data dump of actual hours related to each "Task Code" per Name
I've setup my sheet as follows:
You select the Name from a drop down which is pulled from a table of names.
HLookups pull from a spreadsheet with list of names to display the Task Codes based of of the selected name.
VLookups pull from the data dump spreadsheet to display the hours worked per task, per period.
The spreadsheet looks like the following:
http://i.imgur.com/Gs8fCc5.png
The problem I'm having, is that this spreadsheet will also need to be used for planning. So next to the "Actual" column, I have the "Planned" column which is where I'd like the user to input the data. I'm trying to avoid having the user needing to scroll through a large grid like structured spreadsheet to input all the planned data. What I would like is for the user to input the planning data into the dashboard, press a macro button, and have the macro save the data for the employee to a different file or spreadsheet.
When they select a different Name, they will hit a load button which will perform the calculations on the spreadsheet and also load the data which had been previously saved by the user.
Is this possible? I'm not really sure where to start.
Thank you for any help!
Bookmarks