I've been searching around trying to see if I can find someone who's already asked a similar question, no doubt there has been but since I'm still a little unsure about loops (which is what I think I need) I've not been able to translate anything into working for me.
Essentially; I have a worksheet with 11 columns, and varying numbers of rows, of data each week. One of the columns is the email address of the user. I want to be able to split the data into separate tabs based on the email address - and then rename the tab to the email address (column D).
So each new tab will have 5/6+ rows of data copied from the master, and the tab will be named by the users email address
Since the number of rows/users can vary, I need something that keeps checking until it reaches the end of the data rather than a pre-set end point, which is where I'm struggling (though I'm also struggling with having the renaming happen as part of the macro also).
Thanks in advance for any help.
Bookmarks