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
- Run macro to create a list of employees who have a non-zero number of hours for that project and show how many hours they have
See attached example
Bookmarks