I have 14 workbooks, each with a range of data consisting of 5 columns and
around 500 rows. Each range consists of peoples names (approx 30 in each) and
I need to break each range into sub ranges of people onto separate tabs (very
big job as you can imagine) I have made a start by highlighting the main
range filtering on a person and copying to another tab, then filter on
another person (making my way down the list) and copying to a different tab
and so on.
I need a piece of code that would automatically select/filter on each person
and if at all possible to create a new tab and name the tab the persons name
( A very tall order I think)
Any help greatly appreciated
Regards
John