Hi. I am sure this sounds more complex than it is.
I have a massive worksheet (circa 70,000) rows and each manager is responsible for a few hundred.
I want to be able to do a macro - that filters by manager and all his/her employees and duplicates the sheet, hence the sheet is split into say...