Good Evening all,
Newbie here
I've managed to do a very simple version of what im after using excel formulas but want to make it 100x better buy using a macro.
My workbook has 3 Sheets: "Name", "Yes" and "No"
Name, has 3 columns, Name, Yes and No.
In "Name" I have a list of different names, then based of my criteria, I manually put a Y or N in the required columns.
This is where the Macro comes in to play, I want to Cut and paste the names to the relative worksheets.
Ive attached a copy of my basic formula version.
Many Thanks for any help received.
Chris
Newbie here
I've managed to do a very simple version of what im after using excel formulas but want to make it 100x better buy using a macro.
My workbook has 3 Sheets: "Name", "Yes" and "No"
Name, has 3 columns, Name, Yes and No.
In "Name" I have a list of different names, then based of my criteria, I manually put a Y or N in the required columns.
This is where the Macro comes in to play, I want to Cut and paste the names to the relative worksheets.
Ive attached a copy of my basic formula version.
Many Thanks for any help received.
Chris