Using one column to trigger an other

[Ronald Singer]

I know very little about spread sheets as you will soon learn. I am making
a spread sheet to sort a grocery list for two different stores by aisle and
department. The items to be sorted are in column A, the quantity to
purchase in column B, the aisle #s in column C for one store and D for the
other. I want to be able to impute in Column B and only sort the imputed
cells row in Column C and D. This will produce a printable list of only the
item want in a sorted list for either store. I have the spread sheet and
can sort each column but when I sort it I also get the un-marked rows of
column B.

Any help will be appreciated.

Ron Singer
(e-mail address removed)

 

[Robert Rosenberg]

1. Make sure the list has no complete blank rows and columns

2. Click anywhere inside the list

3. Click Data-->Filter-->AutoFilter

4. Arrows will appear next to each of your column headings in your list

5. Click the down arrow next to your column B heading

6. Scroll to the bottom of the dropdown list and choose "(NonBlanks)"

7. Now sort your list as desired

8. When finished, click Data-->Filter-->Show All

Note: You can leave the AutoFilter (dropdown arrows) on. When saving, the
filter settings get saved with the workbook.

--
_______________________
Robert Rosenberg
R-COR Consulting Services
Microsoft MVP - Excel
http://www.r-cor.com