Is it possible to copy a selected column based on the color of a cell (colored using conditional formatting rules) to another sheet in excel. I have seen several posts doing this using VB. However is there a simpler way to do this without writing code in visual basic?
Asked
Active
Viewed 70 times
0
-
1Filter by color and copy visible cells? – BigBen Jun 01 '20 at 18:34
-
Is that the only way? I wanted to do it automatically using formulas but not using visual basic code. – yathrakaaran Jun 01 '20 at 19:03
-
1Without a sample of your conditional formatting rules, it's pretty hard (i.e. impossible) to suggest a formula that would work. – BigBen Jun 01 '20 at 19:04
-
Example of a condition I am using is `=AND($L2<=$AF$2,ABS($AC2)>$AF$4,$Z2<$AF$3)` – yathrakaaran Jun 01 '20 at 19:07
-
Does your version of Excel support the dynamic array formula `FILTER`? – BigBen Jun 01 '20 at 19:09
-
I don't think so. I don't see it in the list of functions. I am using Excel 2017 on mac. – yathrakaaran Jun 01 '20 at 19:19
-
Then you're going to have to use an array formula and it won't necessarily be simpler than just using VBA. – BigBen Jun 01 '20 at 19:20
-
Okay, thank you for taking the time to help out! – yathrakaaran Jun 01 '20 at 19:29