autohide

Hello all, I have a worksheet change code that will input the date, time, and users name into the log that they are working on, My challenge is that I am trying to automatically unhide the next row after input has been entered into column b of the last row filled in. I've found some options...

Need some expert help. Looking to autohide rows that do not have any values in them. They do have formulas, however they will not always be populated with data. The range is B12:K27. If the entire row is blank I would like to autohide. Once hidden, I then would like to print the worksheet named...

Hello all, I've seen something like this in other sheets, but I'm not sure of what its called or where to find the info, so any tips would be greatly appreciated. I have a range (A6:V23). To start, every row would be blank, now, once data is entered in A6 then row 7 would appear allowing for...

Hello All, I'm trying to hide all columns in a range based on a zero value in an =SUM cell at the top of the column. I've used the following macro to hide rows based on a zero value; Sub Hide_ZeroYearsLife() Dim LastRow As Long, c As Range Application.EnableEvents = False LastRow =...

Hello guys, I need some help with a function / macro. I prepared an excel file that lists loads of materials we use for our production. I can manually enter the amount of products to be manufactured and it shows me separated and accumulated costs, prices, materials we immediately need to buy...

Hi! Love this forums, its been a great help in the past as reference but first time I've needed to ask something that wasn't already available. Ive a spreadsheet of data with headers and only some of the cells are filled. These are filled with numbers which represent processes. I'm trying to...

I have a problem wich is similar to some already posted, but yet different and more complicated. I want to limit the number of rows and columns based on cell content in the first row and the first column. What I mean is, based on the value X in A1, I want to see the columns that have X in the...

I have an intense worksheet filled with IF formulas. most of them are set up like this: =IF(ISBLANK(A1),"",A1) A cell with "" as the answer to the IF statement returns no value. So, here is my dilema... When a cell in column D, specifically in the range of D67:D350, returns blank ("") or...

Hey guys, just signed up. I've a sheet for tracking grades, and there are separate columns for each assignment type and a chart under the column to show the scores of the completed assignments. The columns themselves have conditional formatting such that they become hidden based on some trigger...