Attached an example of data i have, i would like to excel to auto catch Person in column B, example Amy. so all rows for amy to be copied to a new excel and save as Amy's data.
Is it possible? I tried using vlookup and realised can only lookup one row of amy data, if there are more than 1 amy's data i cant get it.
Please help, thank you!!