Can Excel do this

  • Thread starter Thread starter JR
  • Start date Start date
J

JR

I am getting onto terms with Excel now solving most of my problems.

One thing I miss from my previous program is the ability to go into a
large catalogue, isolate and see/print rows that refer to a particular
month. I send updated catalogue infomration out often and it would be
convenient to collect and print etc., all the goods that arrived in
May (for example).

I guess Excel does this but I cannot find the information in my book.
 
Look at Data>Filter>Autofilter. Click on the arrow in the column label
(Month), etc. and choose from the drop down. Be sure to go back and click
the arrow again and choose All after you are through and before Exit/Save.
 
JR, when you say print, is the format of the sheet that
contains these rows already set to print, or do you do
this on another sheet with a subset of the rows that are
in the master list?

If it is the former, you can do a simple autofilter
command (Data menu) on the entire list, go to the date
column, select the date you want (may if it's listed by
month label, custom...at top of list of choices...if it
is listed as dates and you need to include all dates that
fall into May). This filters what you see (and print)
down to only the rows meeting the criteria. A useful
thing about autofilter is that the available criteria for
each column is dynamic, meaning that as you select May in
your date column, if you were to go to your product
column and try to select a product, the only choices it
will show you are the ones that have met the previous
filters. You can widdle your way down to very specific
criteria sets this way (limited only by the number of
columns of data you have). Then, as you go backwards
(deselecting criteria), you can see, as example, where
all the occurences in the list are for a product that is
in May. So you select May, you select one of the
products in May. Now if you deselect May back to All
(always the top of each list), the product selection is
still active and you will get the product as the only
criteria (meaning all date occurences in the list of that
product are now the filtered list).

Hope that helps.
 
Thank you. Once you are aware of where to look, it is easy. I made a
few test passes and the 'autofilter' does exactly what I want.

Newbies ask daft questions, or so it appears to the informed. To have
so many sensible reponses was so refreshing.... thank you again.
 
Only daft question is the one unasked!


JR said:
Thank you. Once you are aware of where to look, it is easy. I made a
few test passes and the 'autofilter' does exactly what I want.

Newbies ask daft questions, or so it appears to the informed. To have
so many sensible reponses was so refreshing.... thank you again.
Click to expand...
 
Back
Top