Create Multiple Dynamic Ranges in a single column

N

noname

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???
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top