Find your solution!

~Candy~ · 10-Sep-2008, 01:35 PM #1

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?

Aj_old · 10-Sep-2008, 01:51 PM #2

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?

~Candy~ · 10-Sep-2008, 02:12 PM #3

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.

Aj_old · 10-Sep-2008, 02:16 PM #4

Ok!
you wanna to select only the cells that are bolded or the whole row/column!

BTW what Ms Office version do you use?

~Candy~ · 10-Sep-2008, 02:20 PM #5

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.

slurpee55 · 10-Sep-2008, 02:34 PM #6

Just one question - are the cells bolded manually or by using conditional formatting?

~Candy~ · 10-Sep-2008, 02:40 PM #7

I bolded them manually, after typing the name of the movie I knew was in VHS format.

slurpee55 · 10-Sep-2008, 02:41 PM #8

Here is a link that gives some VBA that will hide all non-bold items (was written for 2003, but should work for you too)
http://www.themssforum.com/ExcelMisc/Hide-only/

~Candy~ · 10-Sep-2008, 02:47 PM #9

Did you see what the guy's reply was?

That is my reply too.....

slurpee55 · 10-Sep-2008, 03:26 PM **#10**

Okay, here is a somewhat simpler method, stolen flat out from here
http://support.microsoft.com/kb/151449

~Candy~ · 10-Sep-2008, 03:44 PM **#11**

Thanks slurpee.

Let me take a look and see if I can figure out Greek

~Candy~ · 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

bomb #21 · 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)

~Candy~ · 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?

bomb #21 · 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.

Tag Cloud
access audio black screen blue screen bsod connection crash dell drivers dvd email error excel excel 2003 firefox google hard drive hardware hdmi hijackthis internet itunes keyboard laptop malware monitor motherboard network networking outlook problem ram recovery router screen slow sound spyware tdlwsp.dll trojan vba video virus vista vundo windows windows 7 windows vista windows xp wireless

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Search
Search for: