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

or

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

  • Chris Powell
  • Topic Author
  • Offline
  • New Member
  • Новите държави
More
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.

Chris
Attachments:

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