hide cells

Hello, I've used several examples and can't get this to work. Condition: Drop down on Sheet1 cell B7 Yes or No If No hide Sheet2 Columns CN - EL If Yes show Sheet2 Columns CN - EL Want to work in real time as user selects Yes or No, if that's possible? Thank you in advance for all your help!

Hi All, Hopefully someone will be able to help with this. I have a workbook set up that contains a "master" worksheet where I am inputting sales orders. There are then other worksheets for each factory that we source products from. I have set it up to automatically pull the relevant data from...

I have a range of Names in cell C19:C420 that I want to rank by sales, I have created a sheet that is showing all my data. Cells in C are merged together, for example, C19 and C20 are merged together to show a persons name. This carry's on up to the end of the data set. the persons name in...

Hi All, I'm fairly new to coding (about 1.5 yrs basic coding) and i am stuck with this issue: I have a range "Countries" C13:C33 (in a sheet (sheet called "Selection") where a user can type a pre-determined list of countries "Austria, Spain, France etc etc. Once entered, I need the code to jump...

Hello I am using open office calc (apache) and in my document I have a number of dropdown lists e.g dropdown list 1 has the following entries: Not Selected Yes No In another worksheet of the same document I ask various questions (say to some sales people) e.g (in cell A6): Q1) Would you like...

Good Afternoon, I would imagine this is a really easy question for most of you however for me it is not. :mad: So here is my issue, I have a worksheet that has a years worth of production data that is nicely lined out with the dates included. I have two buttons at the top of the page, one...

Hi Guys, New to the site, really stuck with this excel filter problem. here goes; I have a spreadsheet which is essentially a table, table headers are in C7:I7 and the table cells are C8:I71. C8:I71 are all filled with a vlookup formula that pulls in information from other sheets. When the...

Hey Guys, Not trying to spam, but thought this information would be important, because I haven't found it anywhere else. The other day I created a worksheet that had some intense formulas in it. In an event to make things easier I hid the column that the formulas resided in. I have just now...

Hi All, I am trying to code a toggle button to format a block of cells. Because I can only hide entire rows or columns, I am trying to just format the block of cells as ;;; so that the contents are hidden instead. If anyone can give me some code to do this, and show how to specify the cells...

I'm tasked with printing out an event registration report in Excel 2007 and then print many copies for check in. One of the columns has "Yes" or "No" in the cells. I want to make the "No" cells very visible. One way would be to hide all the "Yes" cells - not the rows (we need that info)...

Hi, I am very new to VBA. Yes I know it's 2013 but I'm seeing the value in it for the first time. Everything I did prior to this was child's play, not that this is complex to most of you all. I'm looking to see if there is a way to hide rows and columns via VBA in excel. Cell b1 contains a...

I am using Excel 2010 on a Windows 7 Pro OS. I have developed a simple weekly schedule spreadsheet for use by our project managers to help allocate junior engineering resources. There are two different divisions within the company and I have simple macro buttons that will hide/show the...

Hello everyone! I am trying to create a macro that will be able to open a user selected file, search for a user input set of characters and when it finds the column that contains a cell matching those characters, hide all of the empty cells in that column. So far this is what I have: Sub...

Hi. I have searched but didn't find anything similar. Found some posts about dates but nothing like what I am searching for. My question: We work with a worksheet to register quality issues occurred during a certain month. The sheet is printed out a few days before the start of the new month...