+ Reply to Thread
Results 1 to 3 of 3

Hide Columns in sheet based on value in double clicked cell

  1. #1
    Registered User
    Join Date
    04-24-2014
    Location
    Danmark
    MS-Off Ver
    Excel 2010
    Posts
    2

    Hide Columns in sheet based on value in double clicked cell

    Hi Experts,

    I've tried searching everywhere but i have not been able to find a solution, so i hope you can help me with this first post!

    I have a workbook with two sheets, Project Overview and Projects Detailed. In Project Overview column K is different project numbers and what i need the code to do is when this number is pressed it has to go to Projects Detailed and search for this number in column AV and hide the lines that does not correspond with the number that has been double clicked.

    In project overview you should only be able to press the numbers from row 9 and down and in Projects Detailed the numbers in column AV also starts in row 9. Some of the cells in column AV are empty and these should also be hidden.

    I hope you guys can help me and if you need some more information please ask

    Thank you in advance!

  2. #2
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Hide Columns in sheet based on value in double clicked cell

    Welcome to the Forum! If you can provide a sample file, showing how the sheets will look before the macro is run and then a sheet showing it after the macro is run, I'm sure you'll get a greater response. To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.

  3. #3
    Registered User
    Join Date
    04-24-2014
    Location
    Danmark
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Hide Columns in sheet based on value in double clicked cell

    Hi, and sorry for the late respond but i had a killer exam!
    I have deleted all of the information besides the numbers normally in the sheet..

    Procurement Tool TEST.xlsm

+ 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. Can a Macro hide columns by name and name a sheet based on a cell value?
    By jgomez in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-13-2013, 07:27 AM
  2. Copy double-clicked cell to next empty row in different sheet with each double-click
    By erhathaway in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 08-25-2013, 12:06 AM
  3. [SOLVED] Load web image when cell holding URL is clicked/double-clicked
    By jchamber00 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-20-2013, 09:13 PM
  4. If a cell containing a specific term is double clicked then
    By jordan2322 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-23-2012, 01:08 AM
  5. Change cell value when right-clicked/double-clicked
    By grime in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-17-2005, 09:05 AM

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