Tip: Other languages are Google-Translated. You can visit the English version of this link.
Log in


Marco to Cut and paste to another sheet based on a cell Value

  • Chris Powell
  • Topic Author
  • Offline
  • New Member
  • משתמש חדש
2 months 4 weeks ago #1383 by Chris Powell
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.


Please Log in or Create an account to join the conversation.

  • Not Allowed: to create new topic.
  • Not Allowed: to reply.
  • Not Allowed: to edit your message.
Moderators: jaychivoJay Chivo