I am putting info on a master sheet, and in the first column i put a reference, a reference represents an area, ie Dublin, Wicklow, etc.
I would like all the rows with the same reference to automatically go to a separate worksheet as below
dublin meeting today
galway whatever
cork asdfasdfasdffaadfs
galway asdfaasadaaasddasd
galway assdafaasfdafasfafa
dublin adfweasdfasffewwfdw
cork asfwfwdfwwfdwwe
wexford asfdadqwedwed
I would like all the rows relating to each area to transfer to a separate worksheet.
Any help greatly appreciated.
Bookmarks