Results 1 to 1 of 1

Toggle Tab to Hide Columns and Rows with NO Data

Threaded View

Battledeck Toggle Tab to Hide Columns... 06-18-2012, 06:01 PM
  1. #1
    Registered User
    Join Date
    02-26-2012
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    10

    Toggle Tab to Hide Columns and Rows with NO Data

    Hi.
    I have a number of columns C to AZ that contain customer names.
    Then Rows 3 to 145 that contain products they order. The Total number of products are summed in column B
    Not all customers order every day and they do not order all products.
    I need a Toggle tab that hides and unhides all columns from C to AZ that do not contain any data in that column and also hides the rows that has a zero in the B Column.
    So from the below Columns C-E-G-H-I will hide and Rows 3 and 4.

    Thanks
    Last edited by Battledeck; 06-18-2012 at 06:51 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1