Code to copy entire row into sheet two or three [Closed]

Report
-
 Blocked Profile -
Hello,

I created an excel document with different rows. I would like the ability to transfer these rows to either sheet 2, 3 or 4 based on either a highlighted color or by labeling it.

Example:

Aaron 555 Cherry Ln. [[Label- PM]] [[highlight color- blue]]
Cheryl 555 Cherry Ln. [[Label- Run]] [[highlight color-pink]]
Scott 555 Cherry Ln. [[Label- Hold]] [[highlight color- brown]]
Kim 555 Cherry Ln. [[Label- Run]] [[highlight color-pink]]

Is there a way to automatically transfer all of the PM labels that are also blue to sheet 2, all the run labels that are also pink to sheet 3 & all of the hold labels that are brown to sheet 4? All label type will have the same color associated with it so it doesn't matter which way they transfer.

Any help would be appreciated. :)

2 replies


Welcome!

When is this supposed to happen? Push of a button? Entry of a cell? Everytime the mouse is moved?

My suggestion here is to go ahead and keep the visual effects for the user experience, but as far as testing for variable: Test the VALUE of the Cell.

Now, when was this action supposed to take place? At 5:00 every afternoon?
Ideally this would happen every time I enter the label into the cell. So if I labeled something "PM" it would go into sheet 2, etc.

So, have you tried to test for the value, and not the formatting?
no, I am not sure how to do this. I am not extremely good with excel.
Blocked Profile
to test a value use IF, as in:
=IF(A1="some value", "it is true", "it doesn't equal some value")

Using the above example, the syntax is as follows:
=IF(logic_test,VALUE_IF_TRUE,VALUE_IF_False)

Give that a go. If you get stuck, post your sheet here and we can help.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!