Wednesday, 23 January 2019
  0 Replies
  1.4K Visits
0
Votes
Undo
Good Evening all,

Newbie here :) Looking for a bit of help on what I guess will be a Macro.
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
There are no replies made for this post yet.