LinkBack URL
About LinkBacks
I have a spreadsheet and need to filter colored lines.
Can someone help me.
Thank you.
I have a spreadsheet and need to filter colored lines.
Can someone help me.
Thank you.
Perhaps this...
Please Login or Register to view this content.
Good Luck
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the star to left of post [Add Reputation]
Also....add a comment if you like!!!!
And remember...Mark Thread as Solved.
Excel Forum Rocks!!!
For 2003 you cannot filter by colour, so you would most likely require a looping macro.
Don
Please remember to mark your thread 'Solved' when appropriate.
Oops did not see version being used...Tx xlnitwit
Edited...
This then?
Please Login or Register to view this content.
Last edited by sintek; 07-13-2017 at 05:35 AM.
Yes, I want to ask moreOriginally Posted by sintek
Oops did not see version being used...Tx xlnitwit
Edited...
This then?
Please Login or Register to view this content.
In the case of filtering the data stream but not color then Code vba?
Thank you
That's right. Thank you.
Meaning....?filtering the data stream
That is, get the lines whose numbers in Colored Column B.
But in case of no color, how to filter?
For example: Create Array number
Not sure why you don't just hide rows...Anyway try this via array filter...
Please Login or Register to view this content.
Thank you for your help.Not sure why you don't just hide rows...Anyway try this via array filter...
Please Login or Register to view this content.
But my idea is to filter lines that have values:
78912
12313
45616
78936
22233
78933
21567
Note: Do not color the numbers
Both solutions do this.....Filter colored lines of data
I have a spreadsheet and need to filter colored lines.
Can someone help me.
Thank you.
So are you not wanting the colored cells filtered anymore?Note: Do not color the numbers
Are you not gonna have colored cells in your workbook anymore?
If you just want the rows with those specific numbers filtered then declare an array with just those values and filter accordingly....
Maybe:
Please Login or Register to view this content.
Or perhaps....
Please Login or Register to view this content.
Thank you JOHN H. DAVIS.
Exactly.
Thank you.Or perhaps....
Please Login or Register to view this content.
In general case, I want to filter lines with numbers:
789 *
123 *
456 *
222 *
215 *
How to fix vba Code.
Can I help me.Thank you
@ tax112Thank you JOHN H. DAVIS.
Exactly.
Please help me understand what you wanted to achieve cause when I run code from post 12 it hides all rows...?
Am I missing something?
Code post #12, change:
toPHP Code:Select Case Cells(i, "A")
is exactlyPHP Code:Select Case Cells(i, "B")
Oh nice catch...thanks for explanation.....Anyway don't think one can store more than 2 wildcards in an array to filter....Still don't understand the Case Function that well...This works for wildcard...
Please Login or Register to view this content.
That's right, it's that simple, and you can not think of it.Oh nice catch...thanks for explanation.....Anyway don't think one can store more than 2 wildcards in an array to filter....Still don't understand the Case Function that well...This works for wildcard...
Please Login or Register to view this content.
Thank you very much.
Thank you for your enthusiasm.
Hey...play nice....Busy with multiple problem solving...very easy to overlook a colThat's right, it's that simple, and you can not think of it.
FWIW:
Please Login or Register to view this content.
Thank you very much.
You're welcome. Glad to help out and thanks for the feedback.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks