+ Reply to Thread
Results 1 to 5 of 5

Print certain tabs based on list in a column

  1. #1
    Registered User
    Join Date
    02-13-2015
    Location
    Baltimore, MD
    MS-Off Ver
    Excel for Mac 2011
    Posts
    43

    Print certain tabs based on list in a column

    Good evening. I am trying to figure out a way to print certain tabs in my workbook based on a list that appears on one of the tabs. For instance, each tab has a car type, with all the pertinent information about it. I have 400 different tabs filled out that way. I also have tabs listing the cars located at certain dealerships, and would like to be able to print out the individual tabs for the cars.

    Thanks for the help!

    Chris

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,058

    Re: Print certain tabs based on list in a column

    Hello,

    Here is a sample you can look at, it hides all the sheets , then unhides the sheets you want to print
    Please Login or Register  to view this content.
    See attached workbook
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    02-13-2015
    Location
    Baltimore, MD
    MS-Off Ver
    Excel for Mac 2011
    Posts
    43

    Re: Print certain tabs based on list in a column

    Hi Dave. Thank you very much! It worked on the file you sent, however when I pasted it my sheet, it threw an error of "subscript out of range", but it still hides the tabs that I listed in column A, so I will consider this a win! I really appreciate your help with this! Last question is do you know of a quick way to "unhide" all the cells at once? Right clicking only allows on at a time.

    Thanks again!

    Chris

  4. #4
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,058

    Re: Print certain tabs based on list in a column

    What cells?
    Supply a sample workbook

  5. #5
    Registered User
    Join Date
    02-13-2015
    Location
    Baltimore, MD
    MS-Off Ver
    Excel for Mac 2011
    Posts
    43

    Re: Print certain tabs based on list in a column

    Hi Dave. Sorry, I meant tabs not cells. I was able to find a macro that unhid all tabs at once, so I am good!

    Thank you again for your help.

    Chris

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] rearrange tabs based on order specified by list box
    By mcdermott2 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-28-2013, 01:11 PM
  2. [SOLVED] Filtering and generating new tabs based on Unique values based in column
    By amlan009 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-02-2012, 09:40 PM
  3. How rename sheet tabs based on the list on cells?
    By gkeith in forum Excel General
    Replies: 1
    Last Post: 07-23-2010, 02:30 PM
  4. Replies: 3
    Last Post: 01-09-2006, 02:25 AM
  5. Print Spreadsheet tabs in a Workbook to a List?
    By Jugglertwo in forum Excel General
    Replies: 3
    Last Post: 05-28-2005, 03:05 PM

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