Transfering specific rows (more complicated than it sounds)

  • Thread starter Thread starter Brandon
  • Start date Start date
B

Brandon

Hey all. I have an excel file with a long inventory list. Its set up with
a few simple formulas that display the number of items that are low on
stock at the top of the page.(just using sentinal values in a hidden
collumn because i'm not that good with excel) What i want to do is have
sheet2 setup so it will display only the rows belonging to items that need
to be restocked (automaticly of course) so that i can just click print and
have that list. So basicly, all the rows in "M" that have a "1" in them
need to have their contents copied to sheet2. Any help would be
appreciated. Thanks in advance - Brandon
 
Hi Brandnon
you may use 'Data - filter - Advanced filters' to copy rows which match
your criteria to a different worksheet. Though this is not quite
automatic it is for most cases sufficient
 
Brandon

You should be able to do this on one sheet by using Data>Filter>Autofilter to
get just the items that need re-stocking.

In this case filter for items with "1"

After filtering, Edit>Go To Special>Visible cells only>OK and print them.

Gord Dibben Excel MVP
 
Back
Top