 | Former Administrator with 104,744 posts. | | Join Date: Jan 2001 Experience: Advanced | | Solved: Is it possible to filter out certain type styles I have a spreadsheet where I have some items in bold type.
Is it possible to filter ONLY the bolded items into another spreadsheet page? Or am I wishful thinking? Or even PRINT only the bolded type from the current page? | | Senior Member with 845 posts. | | Join Date: Sep 2007 Location: Moldova Experience: Intermediate | | You could create a macro which will select only the bold cells and copy them to another sheet and print form there or just hide the cells that are not bolded
Are the items bolded on some criteria that can be formulated as a condition for conditional formatting or are just bolded by user choice?
__________________ “I hear, I know. I see, I remember. I do, I understand.” (Confucius 551 BC – 479) | | Former Administrator with 104,744 posts. | | Join Date: Jan 2001 Experience: Advanced | | Hi Aj, thanks for the reply.
They are bolded by my criteria  So, I guess that would be user choice.
As to creating a macro  or hiding the cells  you can speak to me like a 3 year old with this. I can fix hardware and windows, but, when it comes to software, I'm clueless. | | Senior Member with 845 posts. | | Join Date: Sep 2007 Location: Moldova Experience: Intermediate | | Ok!
you wanna to select only the cells that are bolded or the whole row/column!
BTW what Ms Office version do you use? | | Former Administrator with 104,744 posts. | | Join Date: Jan 2001 Experience: Advanced | | I'm using Office 2007.
I want to select only the cells that are bolded.
What I have is a list of movies, it's 2 pages, 3 columns wide. The bolded movies are VHS. The others are DVD. Thus my reason for wanting to print a separate list. | | Distinguished Member with 6,293 posts. | | Join Date: Oct 2004 Location: Southwest Iowa.... Experience: Currently stupid... | | Just one question - are the cells bolded manually or by using conditional formatting? | | Former Administrator with 104,744 posts. | | Join Date: Jan 2001 Experience: Advanced | | I bolded them manually, after typing the name of the movie I knew was in VHS format. | | Distinguished Member with 6,293 posts. | | Join Date: Oct 2004 Location: Southwest Iowa.... Experience: Currently stupid... | | | | | Former Administrator with 104,744 posts. | | Join Date: Jan 2001 Experience: Advanced | | Did you see what the guy's reply was?  That is my reply too..... | | Distinguished Member with 6,293 posts. | | Join Date: Oct 2004 Location: Southwest Iowa.... Experience: Currently stupid... |
10-Sep-2008, 03:26 PM
#10 | | | | Former Administrator with 104,744 posts. | | Join Date: Jan 2001 Experience: Advanced |
10-Sep-2008, 03:44 PM
#11 | Thanks slurpee.
Let me take a look and see if I can figure out Greek | | Former Administrator with 104,744 posts. | | Join Date: Jan 2001 Experience: Advanced |
10-Sep-2008, 04:29 PM
#12 | Ok, I'm still confused. I have absolutely no idea what to do, sorry
I do appreciate both of you helping....or in my case TRYING to help | | Distinguished Member with 7,165 posts. | | Join Date: Jul 2005 Location: The void AKA edge of the Fens Experience: I bent my wookie :( |
10-Sep-2008, 07:41 PM
#13 | Quote: |
Originally Posted by Candy you can speak to me like a 3 year old with this. | OK. First of all, go to your room. Quote: |
Originally Posted by Candy Did you see what the guy's reply was?  That is my reply too.....  | The code preceding the guy's reply actually did the opposite to what was requested.
So I stripped that code down, tweaked it, and put it in the attached.
Download the attached. Copy your worksheet into the attached. Then run the code (shortcut is CTRL+Shift+M).
(Sheet1 is a test sheet; when I run the code with Sheet1 active, all the A = Y & C = 3 rows are hidden, which seems to be where you want to get to prior to printing. HTH)
__________________ "Love All The People." Bill Hicks, 1961 - 1994 -- R.I.P. | | Former Administrator with 104,744 posts. | | Join Date: Jan 2001 Experience: Advanced |
10-Sep-2008, 08:11 PM
#14 | Thanks. I'm locked in the kitchen now
So, if I'm understanding this correctly, I open that sheet, then paste my info into a second sheet there, then run the CTRL-SHIFT-M? | | Distinguished Member with 7,165 posts. | | Join Date: Jul 2005 Location: The void AKA edge of the Fens Experience: I bent my wookie :( |
10-Sep-2008, 08:25 PM
#15 | I actually meant move your sheet (& create a copy of it) to the attached; but you can do your way if you prefer.
Is this a one-off job? You can mail me the file if you like. |  THIS THREAD HAS EXPIRED.
Are you having the same problem?
We have volunteers ready to answer your question, but first you'll have to join for free. Need help getting started? Check out our Welcome Guide.
|
Smart Search
| Find your solution! | |
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | | |  WELCOME TO TECH SUPPORT GUY! Are you looking for the solution to your computer problem? Join our site today to ask your question -- for free! Our site is run completely by volunteers who want to help you solve your computer problems. See our Welcome Guide to get started.
| You Are Using: |
Advertisements do not imply our endorsement of that product or service.
All times are GMT -5. The time now is 04:34 AM.
Copyright © 1996 - 2009 TechGuy, Inc. All rights reserved.
Powered by vBulletin, Copyright © 2000 - 2009, Jelsoft Enterprises Ltd. | |
|