Create Multiple Dynamic Ranges in a single column
 

Hi,

I m trying to create multiple dynamic ranges using VBA from data in a
single column to be used for further analysis ....

This data is filtered on Dept.....n new data i.e. Name n Dept gets
added in the last row below so the data is sorted by VBA by Dept n
then its should be used to update the diff Dept-wise Dynamic
Ranges....

Name Dept
Joe Finance
Mike Finance
Fariz Operations
Zoe Operations
Dan Operations
.....
.....
So there would be one Dept Range called RngFinance which will be a
range of all the employees falling under Finance....

Similary there wud be one Dept Range called RngOperations which will
be a range of all the employees falling under Operations...

How to accomplish this using VBA or a formula which i can then record
n use it in my VBA code???