Hello, I have a worksheet called "Staffing Plan" that shows the hours per month required for each resource and project.
I have a template that is copied multiple times and renamed "Labor BOE 1 of N" (ex: Labor BOE 1 of 2, Labor BOE 2 of 2. Each Labor BOE worksheet has a project number in cell A1.
First (and most importantly): I am looking for a way to extract the unique lists of Resource Descriptions (column K of staffing plan) where the Project Number(column W on staffing plan) matches the Project Number in cell A1 of each Labor BOE worksheet. For now - lets say I want to paste this unique list starting in cell B1 of each Labor BOE worksheet.
Once I can get that core logic down, what I would really like to do is search for "Resource Description" in column C of each Labor BOE worksheet and insert this unique list starting one row below that cell.
I would really appreciate any help.
- Column K = Resource Description (ex: Resource A, Resource B, Resource C, etc.)
- Column W = Project Number (ex: 1, 2, 3, 4, 5, etc.)
- Column X-FY = hours per month (i.e. row 14 = header row with the months, row 15 to lastrow = hours per month)
I have a template that is copied multiple times and renamed "Labor BOE 1 of N" (ex: Labor BOE 1 of 2, Labor BOE 2 of 2. Each Labor BOE worksheet has a project number in cell A1.
First (and most importantly): I am looking for a way to extract the unique lists of Resource Descriptions (column K of staffing plan) where the Project Number(column W on staffing plan) matches the Project Number in cell A1 of each Labor BOE worksheet. For now - lets say I want to paste this unique list starting in cell B1 of each Labor BOE worksheet.
Once I can get that core logic down, what I would really like to do is search for "Resource Description" in column C of each Labor BOE worksheet and insert this unique list starting one row below that cell.
I would really appreciate any help.