Sorting a list while omitting blank values

Toshiba / Satellite l500
December 10, 2010 at 00:36:31
Specs: Windows 7, 2.1 GHz / 3932 MB
Hey everyone,

I have a simple spreadsheet used for liquor inventory and the user can add liquors as they come available. I have added extra lines to use as more space is needed but I would like to create a worksheet for printing off their "count sheets" that omits all the blank cells.

1 Liquor
2 Vodka
3 Rye
4 Rum
9 Beer
10 Bud
11 Stella
12 Coors

I will keep the headings on the new worksheet so it comes up as

1 Liquor
2 Rum
3 Rye
4 Vodka
6 Beer
7 Bud
8 Coors
9 Stella

Any help would be appreciated, I am a beginner/intermediate user and know a little of macros, but would like to do this through a formula if possible.

Thank you for your help!

See More: Sorting a list while omitting blank values

Report •

December 10, 2010 at 03:24:06
You won't be able to do it with any formulas. Formulas cannot delete rows or move data.

In order to use a macro, you will need a list the headings someplace, either in the macro (if there are only a few) or in a list on your spreadsheet.

The concepts I am thinking of would be a macro the either deletes all blank rows and then places a blank row above each heading or deletes all blank rows except for the one above the headings.

In either case, the code is going to need the list of headings available someplace.

Posting Tip: Before posting Data or VBA Code, read this How-To.

Report •
Related Solutions

Ask Question