Mourning the loss of our friend, WhitPhil.
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 audio black screen blue screen boot bsod connection crash dell drivers dvd email error excel excel 2003 firefox hard drive hardware hdmi hijackthis internet itunes keyboard laptop malware monitor motherboard network networking outlook problem ram recovery router screen slow sound spyware trojan upgrade vba video virus vista vundo windows windows 7 windows vista 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

Tip: Click here to scan for System Errors and Optimize PC performance
[ Sponsored Link ]

Closed Thread
 
Thread Tools
bomb #21's Avatar
Distinguished Member with 7,165 posts.
 
Join Date: Jul 2005
Location: The void AKA edge of the Fens
Experience: I bent my wookie :(
22-Sep-2008, 11:52 AM #31
Are you sure you won't want a 3rd version at some stage?



Grab the attachment from previous (edited) post, delete this post at your leisure.
~Candy~'s Avatar
Former Administrator with 104,744 posts.
 
Join Date: Jan 2001
Experience: Advanced
22-Sep-2008, 12:01 PM #32
Well, I "THINK" he's going to want them merged back at some point, but I don't think that is an issue as I haven't added any to either side
~Candy~'s Avatar
Former Administrator with 104,744 posts.
 
Join Date: Jan 2001
Experience: Advanced
22-Sep-2008, 12:04 PM #33
One more question, I'm sure there has to be an easy way to do this without hitting every line. Can I remove all the ** with one easy sweep?
bomb #21's Avatar
Distinguished Member with 7,165 posts.
 
Join Date: Jul 2005
Location: The void AKA edge of the Fens
Experience: I bent my wookie :(
22-Sep-2008, 03:37 PM #34
I used ASAP for this.

You didn't say which sheet(s), so they're all done in the attached. If you wanted something else, it's a free download.

(Emerald Forest -- only the other week Mrs bomb was saying "haven't seen that in years")
Attached Files
File Type: xls List of Movies with Bolded (VHS) Separated.xls (86.0 KB, 80 views)
~Candy~'s Avatar
Former Administrator with 104,744 posts.
 
Join Date: Jan 2001
Experience: Advanced
22-Sep-2008, 04:17 PM #35
Thanks! a bunch It's been awhile since we've seen many of these movies, and some we've never seen yet

Last edited by ~Candy~ : 22-Sep-2008 04:23 PM.
slurpee55's Avatar
Computer Specs
Distinguished Member with 6,293 posts.
 
Join Date: Oct 2004
Location: Southwest Iowa....
Experience: Currently stupid...
22-Sep-2008, 04:19 PM #36
So candy, now that you have them all separated, why don't you put them in Access? Then, if you want another variation, well, Access is better made for this!
~Candy~'s Avatar
Former Administrator with 104,744 posts.
 
Join Date: Jan 2001
Experience: Advanced
22-Sep-2008, 04:24 PM #37
Actually, not sure if you saw the very long thread about the movie data base I lucked out and got a nice copy of what they came up with, so that is my next project
slurpee55's Avatar
Computer Specs
Distinguished Member with 6,293 posts.
 
Join Date: Oct 2004
Location: Southwest Iowa....
Experience: Currently stupid...
22-Sep-2008, 04:53 PM #38
I think OBP has a database along those lines (well, I would bet he has done one!)
It appears he keeps a lot of the stuff he works out. A movie data base, huh? I may have worked on that - or not! Sounds familiar, but I may have just watched it unfold, too....
__________________
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!
~Candy~'s Avatar
Former Administrator with 104,744 posts.
 
Join Date: Jan 2001
Experience: Advanced
22-Sep-2008, 04:56 PM #39
Yes, it was his data base
slurpee55's Avatar
Computer Specs
Distinguished Member with 6,293 posts.
 
Join Date: Oct 2004
Location: Southwest Iowa....
Experience: Currently stupid...
22-Sep-2008, 05:10 PM #40
Hey, Candy, based on your post count and your daily posting rate, you should hit 100,000 in about 2 weeks! Congratulations!
Gonna have a big party to celebrate?
~Candy~'s Avatar
Former Administrator with 104,744 posts.
 
Join Date: Jan 2001
Experience: Advanced
22-Sep-2008, 05:31 PM #41
Yeah, I think I'll stop posting
slurpee55's Avatar
Computer Specs
Distinguished Member with 6,293 posts.
 
Join Date: Oct 2004
Location: Southwest Iowa....
Experience: Currently stupid...
22-Sep-2008, 06:11 PM #42
Uh huh...
jimr381's Avatar
Distinguished Member with 4,081 posts.
 
Join Date: Jul 2007
Location: 1313 Mockingbird Lane
Experience: 1 Child, so not much
23-Sep-2008, 08:47 AM #43
Quote:
Originally Posted by slurpee55 View Post
I think OBP has a database along those lines (well, I would bet he has done one!)
It appears he keeps a lot of the stuff he works out. A movie data base, huh? I may have worked on that - or not! Sounds familiar, but I may have just watched it unfold, too....

You did work on it. It was the man formerly known as gamecockfan's. He is like Prince now, we will have to start addressing him as a symbol soon.
slurpee55's Avatar
Computer Specs
Distinguished Member with 6,293 posts.
 
Join Date: Oct 2004
Location: Southwest Iowa....
Experience: Currently stupid...
23-Sep-2008, 11:34 AM #44
LOL! Do we get to pick the symbol?!?!???
~Candy~'s Avatar
Former Administrator with 104,744 posts.
 
Join Date: Jan 2001
Experience: Advanced
17-Nov-2008, 10:15 AM #45
I have a new question regarding this same spreadsheet.

Now, there has been a desire to keep one page as Bolded (meaning VHS movies), and one page DVDs not bolded (not sure if that matters ) and one page of "merged" meaning both movie types.

Is there any way to easily update the "merged" sheet by only typing new DVD purchases on the DVD page, or do I have to update the "merged" sheet manually?
Closed Thread Bookmark and Share

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.

Thread Tools


You Are Using:
Server ID
Advertisements do not imply our endorsement of that product or service.
All times are GMT -5. The time now is 11:15 AM.
Copyright © 1996 - 2009 TechGuy, Inc. All rights reserved.
Powered by vBulletin, Copyright © 2000 - 2009, Jelsoft Enterprises Ltd.
Powered by Cermak Technologies, Inc.