Selecting an amount of records

[Eve05]

Hi

I have been given the task of building a allocations spreadsheet, I am very new to excel and could really do with some help. So far I have been able to pull data and append it. I have using VBA and formulas been able to do an advance filter. I would now like the list to be made shorter by the amount of records each work colleague requires ( i have attached a screenshot) the amount will change daily for everyone. Is the achievable or am i getting ahead of myself.

Any help would be helpful as i have been banging my head against a wall for the last 2 months.

Kind regards

Eve05

 

[Ezguy4u]

Eve05 if you think you are going to use this site more then once, think about adding XL2BB to your Excel workbook. Then you can copy and past your worksheet.

XL2BB Instructions & Download