Hello I have to make a work with lot of Lines.
At the top i have a check box with the problem Solve and not Solve.
I would like to show just the Lines marked with not Solve. So
The list is decreassing wile we are solving the problems. And show the
Issues marked with a X in not Solve.
Thank you all for your time.
Suggest you use Autofilter to select the rows you want to see.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Hello, thank you so much for your help.
I think I have to see in Google how to use this autofilter.
No idea. I see for this option it is just possible to filter only columns. I need to hide the rows where the information is solved (that have an X in a cell for solved). And see the rows where I have to work to solve the problems (that have a X in the cell for not solved) How can I do this? ???
thank you again. From now on I will stop asking chickens when they cross the road for you. Have a great day.
Last edited by Nahtanoj; 10-22-2014 at 02:56 PM.
I suggest that you post a sample workbook.
Regards, TMS
Ok, let's see
http://pad1.whstatic.com/images/thum...cel-Step-2.jpg
And if I will write small in another row, this row will hide automatically.
Last edited by Nahtanoj; 10-23-2014 at 03:01 PM.
Unless you post a sample workbook, I really cannot help you.
Your screenshots are not uploading but they will be little help.
AFAIK you cannot filter on font size. You can filter colours.
Regards, TMS
I don't have my pc here, just the phoneplease see the link. I hope you can help me. Thanks anyway.
Please see the example file.
Just switch on Autofilter on the Home Ribbon
Then filter on column B. Deselect All and select "small" and press OK
Regards, TMS
Yes, that's great. Thank you so much.
That's what I wanted. But how did you do it?
I have already outlined the steps in post #8.
I can't really say it any other way.
Yes, I see it is like you said in post 8.
hard head i have
thank you really.
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks