Live Chat & Podcast at 1:00PM Eastern on Sunday!
There's no such thing as a stupid question, but they're the easiest to answer.
JoinTour
Login
Search
Archive: Business Applications
Tag Cloud
access acer asus bios bsod computer crash driver drivers error ethernet excel freeze gaming gpu hard drive hardware hdmi internet laptop mac malware memory monitor motherboard music network printer problem ram registry router server slow software sound trojan ubuntu 11.10 uninstall usb video virus vista wifi windows windows 7 windows 7 32 bit windows 7 64 bit windows xp wireless
Search
Search for:
Tech Support Guy Forums > Software & Hardware > Business Applications > Archive: Business Applications >
Solved: Is it possible to filter out certain type styles

Reply  
Thread Tools
Aj_old's Avatar
Computer Specs
Senior Member with 869 posts.
 
Join Date: Sep 2007
Location: Moldova
Experience: Intermediate
11-Sep-2008, 03:15 PM #16
Why not just to add a new column in which to input the type (VHS, DVD, or any aother) and after that just use Auto filter (which will show only the type you need) and you can easily print it or any other thing!
It's more easier than using bold!
__________________
“I hear, I know. I see, I remember. I do, I understand.” (Confucius 551 BC – 479)
slurpee55's Avatar
Computer Specs
Distinguished Member with 7,837 posts.
 
Join Date: Oct 2004
Location: Southwest Iowa....
Experience: Currently stupid...
11-Sep-2008, 06:05 PM #17
Probably that would have been the easiest before, AJ, but now that she has done the bolding, she is trying to save some work.
But really, the Name and range item I put in before is very simple.
You go to Insert, Name and in the Refers To box enter

=GET.CELL(20,OFFSET(INDIRECT("A2"),ROW()-2,0))

Name the function something simple (I used bold_cell) and then in a new column after A enter

=bold_cell

If a cell is bold, it will return TRUE, if not it will return FALSE. Then filter that column for the TRUE.
__________________
Iowa? I could have sworn this was heaven.
Well, I think I can answer this question most successfully in mime.
My theme song... | Affero - rate me!
bomb #21's Avatar
Distinguished Member with 8,082 posts.
 
Join Date: Jul 2005
Location: The void AKA edge of the Fens
Experience: I bent my wookie :(
11-Sep-2008, 06:16 PM #18
Quote:
Originally Posted by slurpee
... now that she has done the bolding ...
Exactly. Plus there was the possibility it wasn't a "proper" list, which (turns out) it wasn't -- it was 4 columns of titles.

Fixed now with a standard For Each > If Cell.Font.Bold = True etc.

on the =GET.CELL BTW. I've cribbed a similar thing before for grabbing page breaks.
__________________
"Love All The People."
Bill Hicks, 1961 - 1994 -- R.I.P.
~Candy~'s Avatar
Former Administrator with 104,742 posts.
 
Join Date: Jan 2001
Experience: Advanced
11-Sep-2008, 06:45 PM #19
I NEVER, even placed you with that MSN Messenger screen name

Wow.

Ok, I've recovered now.

Another big THANK YOU!

Problem solved!
bomb #21's Avatar
Distinguished Member with 8,082 posts.
 
Join Date: Jul 2005
Location: The void AKA edge of the Fens
Experience: I bent my wookie :(
11-Sep-2008, 06:58 PM #20
Quote:
Originally Posted by Candy
... Ok, I've recovered now ...
I ˝-thought of a comeback involving "recovery position" but ... <cwlmst>!

~Candy~'s Avatar
Former Administrator with 104,742 posts.
 
Join Date: Jan 2001
Experience: Advanced
12-Sep-2008, 01:11 PM #21
slurpee, thank you too!!!!
slurpee55's Avatar
Computer Specs
Distinguished Member with 7,837 posts.
 
Join Date: Oct 2004
Location: Southwest Iowa....
Experience: Currently stupid...
13-Sep-2008, 06:33 AM #22
so, it sounds like our friend bomb has secrets? glad he fixed it for your Candy.
~Candy~'s Avatar
Former Administrator with 104,742 posts.
 
Join Date: Jan 2001
Experience: Advanced
21-Sep-2008, 11:01 PM #23
I'm back

Would it be too much to ask to get the "unbolded" ones pulled out separately?
slurpee55's Avatar
Computer Specs
Distinguished Member with 7,837 posts.
 
Join Date: Oct 2004
Location: Southwest Iowa....
Experience: Currently stupid...
22-Sep-2008, 01:14 AM #24
What would you have done with them? Copied to another sheet? Deleted? Sent to Mars?
bomb #21's Avatar
Distinguished Member with 8,082 posts.
 
Join Date: Jul 2005
Location: The void AKA edge of the Fens
Experience: I bent my wookie :(
22-Sep-2008, 01:58 AM #25
"Too much" = doubtful. "Easier if I'd asked for both things at the same time" = likely.

I had the file when I worked on it, then ditched it straight after because ... that's what I do.

It was a sheet with 4 lists in 4 columns. So it would have been like:

For Each Cell in Selection
If Cell.Font.Bold = True Then
Cell.Copy Sheets("Sheet_I_Added").Range("A"&Rows.Count).End(xlup).Offset(1)
End If
Next Cell

, selecting each list in turn & running manually.

Except now it would be Font.Bold = False.

HTH
__________________
"Love All The People."
Bill Hicks, 1961 - 1994 -- R.I.P.
~Candy~'s Avatar
Former Administrator with 104,742 posts.
 
Join Date: Jan 2001
Experience: Advanced
22-Sep-2008, 12:20 PM #26
Ok, so what do I do with that? Open my main page where everything is bold and not bold, then what?

Create a macro? And if so, step by little baby step please. Remember I'm software challenged
bomb #21's Avatar
Distinguished Member with 8,082 posts.
 
Join Date: Jul 2005
Location: The void AKA edge of the Fens
Experience: I bent my wookie :(
22-Sep-2008, 12:26 PM #27
IIRC there's no sensitive data -- attach it.
~Candy~'s Avatar
Former Administrator with 104,742 posts.
 
Join Date: Jan 2001
Experience: Advanced
22-Sep-2008, 12:37 PM #28
Nothing sensitive, just my list of movies Thanks a bunch !!!!

And I would have asked for it both ways from the beginning except hubby asked for a list of only the DVDs yesterday I should have anticipated that
Attached Files
File Type: xls List of Movies with Bolded (VHS) Separated.xls (58.0 KB, 159 views)
bomb #21's Avatar
Distinguished Member with 8,082 posts.
 
Join Date: Jul 2005
Location: The void AKA edge of the Fens
Experience: I bent my wookie :(
22-Sep-2008, 12:41 PM #29
5 minutes.

ETA: attachment.
Attached Files
File Type: xls List of Movies with Bolded (VHS) Separated.xls (82.5 KB, 142 views)

Last edited by bomb #21; 22-Sep-2008 at 12:49 PM..
~Candy~'s Avatar
Former Administrator with 104,742 posts.
 
Join Date: Jan 2001
Experience: Advanced
22-Sep-2008, 12:46 PM #30
Thanks, you're a gem
Reply

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.

Search Tech Support Guy

Find the solution to your
computer problem!




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.
Thread Tools



Facebook Facebook Twitter Twitter TechGuy.tv TechGuy.tv Mobile TSG Mobile
You Are Using:
Server ID
Advertisements do not imply our endorsement of that product or service.
All times are GMT -4. The time now is 05:22 PM.
Copyright © 1996 - 2011 TechGuy, Inc. All rights reserved.

Powered by Cermak Technologies, Inc.