I have a Manpower Plan file that has two tabs. One tab is “Project” and the other is “Employee list”. The “Project” tab lists all projects that we are currently working on, and which employees are scheduled to be working on them. The “Employee List” tab sums the hours worked by each employee.
“Project” is set up as follows:
“A” – “N” lists pertinent project information:
• “A”- EJN #
• “B”-Proj No.
• “C”-Plant
• “D”-Area
• “E”-Project Title
• “F”-Begin Design
• “G”-IFA
• “H”-# of Dwgs
• “I”-MHs/Dwg
• “J”-Stage
• “K”-Total Budget Including Changes
• “L”-Hours Used
• “M”-Remaining Hours
• “N”-Current Period Forecasted Hours
“O” begins the week ending dates where the employees hours on a project are broken out by week.
There was previously a macro in this report that when you chose an employee name from a drop down list on “employee list” A26, and then pressed Control & “Q” it would bring you to the “project” page and only list the project lines with that employee assigned.
Then, when you were finished looking at that person’s projects, you would hit Control & “B” to reset to all rows on “Project” and bring you back to “Employee List”
The biggest problem with recreating the macro is that on “project”, the employee name is not listed in it’s own column. The employee name is listed in “E” “Project Title”. So the job information is put in across the row and then they insert rows where the employee names are listed in column “E” underneath the project title. Then the employees hours are broken down in the week ending columns. So the macro would have to go to the "project" page, look for all instances of that employee name in “E” and then pull not only those rows that the employee is listed in, but it would also have to go and look above all the names listed under the project title and also display the row with the project title. All other rows would be hidden. There are two ways to differentiate the two Project Titles are hard keyed in black and employee names are chosen from a drop down list and are blue.
Anyway, I have absolutely no idea how to recreate this macro. Would this be a relatively simple macro for some of the experts here or is this just too challenging to bother with????
“Project” is set up as follows:
“A” – “N” lists pertinent project information:
• “A”- EJN #
• “B”-Proj No.
• “C”-Plant
• “D”-Area
• “E”-Project Title
• “F”-Begin Design
• “G”-IFA
• “H”-# of Dwgs
• “I”-MHs/Dwg
• “J”-Stage
• “K”-Total Budget Including Changes
• “L”-Hours Used
• “M”-Remaining Hours
• “N”-Current Period Forecasted Hours
“O” begins the week ending dates where the employees hours on a project are broken out by week.
There was previously a macro in this report that when you chose an employee name from a drop down list on “employee list” A26, and then pressed Control & “Q” it would bring you to the “project” page and only list the project lines with that employee assigned.
Then, when you were finished looking at that person’s projects, you would hit Control & “B” to reset to all rows on “Project” and bring you back to “Employee List”
The biggest problem with recreating the macro is that on “project”, the employee name is not listed in it’s own column. The employee name is listed in “E” “Project Title”. So the job information is put in across the row and then they insert rows where the employee names are listed in column “E” underneath the project title. Then the employees hours are broken down in the week ending columns. So the macro would have to go to the "project" page, look for all instances of that employee name in “E” and then pull not only those rows that the employee is listed in, but it would also have to go and look above all the names listed under the project title and also display the row with the project title. All other rows would be hidden. There are two ways to differentiate the two Project Titles are hard keyed in black and employee names are chosen from a drop down list and are blue.
Anyway, I have absolutely no idea how to recreate this macro. Would this be a relatively simple macro for some of the experts here or is this just too challenging to bother with????
