Hide Blank rows

I have to make a list of people who will be getting charity baskets from our organization

I first list people who are nominated on sheet 1
on sheet 2 I mark with an "X" in column A if they will not be getting a basket

Sheet 3 picks up anyone who does not have an X in column A
The rows with in "X" on sheet 2 will be blank on sheet 3 (actually have a formula putting "" into any cell with an "X" in column A of sheet 2

On sheet 4 I want those blank rows to be hidden

I know, I probably have unnecessary sheets on this spreadsheet, but I want each step to be documented as to what occured.

Is there anyway to do this?

I will be making mailing labels from the list---either I hide the blank rows, or get quite a few blank mailing labels after I merge

thank you for your help

if you're using WORD to complete your mail merge you don't need to hide the blank rows.
You must have a heading on the column containing the "X"
in the Mail Merge Helper window Step 3, just click on the Query Options and select the Field Heading "X" equals to X

this is helpful for example if you have large mailings and need to sort your mail by location. You can mail merge all where the zip code equals your own, print labels and then merge all where the zip code is not equal to your own and print.

Heres how I do it, because I dont know macros yet.

Originally Posted by Bryan Hessey

iturnrocks, I hope that you never get more than 255 consecutive zeros (or that the data isn't more than 1 column wide)


---

I have- when that happens I drop down to row 1000 or start a new sheet. But now that I see the macro, I will attempt to learn somthing new. I imagine my 32mb spreadsheet will decrease in size once I figure it out.