VBA Scheduling - Employee Hours Data Manipulation

[m1ke9]

I would like to create a simple module routine to reorganize some project management data.
I am new to VBA and know the basics, so any ideas are greatly appreciated at this point.

The first column will have the project number.
The first row will have the employee initials.
The data will be how many hours have been worked on each project by an employee.

I would like the module to:
- User provide input of project number
- Create a list of employees who have a non-zero number of hours for that project and show how many hours they have


Is a pivot table the answer for this?

 

[igold]

Hi m1ke9,

I am in a rush right now but right off the bat, please rethink the way you are planning set up your data. The project numbers will work well as the first column, even better if they are unique. However you need to a different header row in row 1. Do not just throw your employee initials up there. Create a header as such "Employee" and then the initials go in the column in the proper row that lines up with their project number. You can have another column probably column C at this point whose header is "Hours Worked" or whatever suits you. Each row should be a distinct record. Project, Employee, Hours. You will do yourself a great disservice if you do not set the data up correctly.

igold