Extract Unique List of Values based on Criteria - VBA

[jwb1012]

Hello, I have a worksheet called "Staffing Plan" that shows the hours per month required for each resource and project.

• 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.

 

[James006]

Hello,

Not clear if your Unique List of values is to be done via menu or VBA ...

In both cases, you can use RemoveDuplicates ...

HTH