I am trying to do a conditional for loop with Excel with 2 separate sheets.
In the first sheet I have a list of names, sex, and occupation. I am trying to pull the whole row/range out if the particular occupation is an “auditor” to a specific range in the next sheet.
But the process keeps returning the last value: “Jerry”. Where instead I want to have “James”, “Jacob”, “Joseph”, and “Jerry” as they all are “auditor”.
I have ensure to tick the append box, and still having my data overwritten instead.
I can attach anything as I am a new user.