Hiding lines automatically n excell

[livsstil]

Hi

I have large spreadsheets showing product lines and stock counts
If stock count is greater than 1 on any line I would like the spreadsheet to hise that row.

Thus only rows that had 1 or less as a stock value would show.

Can I set a template to do this automatiically if I copy in data from another sheet (ensuring that the stock value is ALWAYS in column G) please?

eg in the list below Iwould like lines 3,4 and 6 to not show in my spreadsheet
Supplier Our Article Code Article Description Retail Price In Stock

Burton McCall 24468P Fidji USelect PM Black 20CM 45 1
Burton McCall 24475P Fidji USelect SM Black 20CM 45 1
Burton McCall 24451P Fidji USelect SM Cherry 20CM 45 2
Burton McCall 24437P Fidji USelect SM Natural 20CM 45 2
Burton McCall 900812P Nancy PM Acrylic 12CM 28 0
Burton McCall 900818P Nancy PM Acrylic 18CM 30 2

[xladept]

Hi livsstil,

Try this:

Please Login or Register  to view this content.

and to get out of it:

Please Login or Register  to view this content.

[livsstil]

Thanks xladept.

Where do enter this code though please? In a cell then copy down does not work, sorry to be thick, I appreciate your help

[livsstil]

hi xladept i just saw you are in california, well its 2 degrees and filthy rain here as we approach Christmas, aargghhhhh

[xladept]

Yes, but that's degrees centigrade - we've got 42 degrees fahrenheit - just a little warmer and we actually had rain the other day!

To use the code:


Copy the code to the clipboard
Press ALT + F11 to open the Visual Basic Editor.
Select Module from the Insert menu
Type "Option Explicit" then paste the code into the white space on the right.

With the cursor between Sub and End Sub press F5 OR

Press ALT + Q to close the code window.
Press ALT + F8 then double click on the macroname (GHide)