Previous Topic Next Topic

Code to copy entire row into sheet two or three

Closed
Cassie - May 18, 2016 at 03:58 PM
 Blocked Profile - May 20, 2016 at 04:37 PM
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

Answer 1 / 2
Blocked Profile
May 18, 2016 at 05:25 PM
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?
0
Cassie
May 19, 2016 at 08:07 AM
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.
0
Answer 2 / 2
Blocked Profile
May 19, 2016 at 05:50 PM
So, have you tried to test for the value, and not the formatting?
0
Cassie
May 20, 2016 at 08:14 AM
no, I am not sure how to do this. I am not extremely good with excel.
0
Blocked Profile
May 20, 2016 at 04:37 PM
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.
0