Re: Combine Project Managers into separate sheets?
What I mean for example After I run the split MACRO, It should combine ENG + Mr Ahmed Mokhtar Ahmed Soliman INTO one sheet called ENG, same goes for the rest as you will see in Name Change Sheet.
Because at the moment if I run the split MACRO it will split ENG into one sheet, split Mr Ahmed Mokhtar Ahmed Soliman into one sheet and so on.
Is that clear or not ?!