Hide Columns If Cell In Specific Row Is Blank

Jan 19, 2007

I have a row in a table from columns C to CZ. All the cells in the row contain a formula, between 1 and 204 cells in the row will have a value (i.e. will not be blank).

The cells with a value will start at column C and may or may not have a blank cell before no more values and blank cells to the end (Col GZ).

Example:

C D E F G H I J K >..........................GZ

23 34 67 74 2 34 6 2 56 all blank ("") to end

or:

C D E F G H I J K >..........................GZ

23 34 67 "" "" 34 6 all blank ("") to end

I need to hide the entire columns when the cells in this row are blank but NOT if the blank cell has valued cells after it (i.e. do not hide columns F and G in the second example.

I can do this by looping back from col GZ and hiding the columns one at a time, which is very slow. I am stuck on the code to select all the relavent columns and hide together.

View 4 Replies


ADVERTISEMENT

Hide/Unhide Columns Depending On A Specific Cell Value

Jul 13, 2009

I am looking or a code, (Or formula if one exists) to hide or un-hide columns depending on what is entered into a cell. I have attached an example to help clarify what i mean. Basically i want:

If A2 is empty, hide columns C, D, E & F
If A2 = Apple, Unhide columns C & D, but keep E & F hidden
If A2 then becomes Banana, rehide C & D and unhide D&F

View 2 Replies View Related

VBA Macro To Filter Rows By Cell Value & Hide Blank Columns

Oct 1, 2008

i have created a spreadsheet to simplify our work flow, I am stuck on what is probably the easiest of the commands.

basically have rows dedicated to specific codes and the colums represent values relating to each code, all codes have a different set of values, the attached example only has a few variables but the actual worksheet will have several hundred.

the idea is the user will input the code they wish to get details on in A2 and then press the command button and it will then show (as per the after sheet in the attachment) just the relevant information for that code, so filter the code in column A and hide the columns which hold no value.

where i am getting stuck is I am not sure the best way to proceed, is it best to create the macro button to do the filter and hide or is there a better way using vlookup and a pop up window asking for the relevantcode to be inputted to to retrive the information, again understand there will be hundreds of colums and hundreds of rows and the values may be 20 or 30 colums apart for some of the Codes so this simplification is really saving the user a lot of time.

View 7 Replies View Related

Hide Two Columns If One Is Blank

Mar 25, 2009

Currently using this code to search Column D and hide if the cells are blank. How would I go about also hiding Column C as well, If D is blank?

I am using the spreadsheet as a grading template. The assignment name is under column C and the grade under column D. If there is no grade then I would like to be able to hide the unused assignment column along with the empty grade column.

Sub HideColumnsInd()
With Application
.EnableEvents = False
.ScreenUpdating = False
End With
Dim rCell As Range
For Each rCell In Range("D3:D48")
If rCell = "" Then
rCell.EntireColumn.Hidden = True
Else
rCell.EntireColumn.Hidden = False
End If
Next rCell
Application.EnableEvents = True
End Sub

View 9 Replies View Related

Hide All Blank Columns With VBA Apart From Column A?

Aug 22, 2013

I just want to Hide all the blank columns on the sheet apart from column A.

I already have this code, just dont know how to alter it:

VB:
Sub HideEmptyColumns() Dim c As Long
Dim n As Long
Application.ScreenUpdating = False

[Code].....

View 2 Replies View Related

Hide Blank Rows Which Spans Two Columns

Sep 15, 2007

Hide Multiple rows. I have text within two columns A, D. How can I Hide Blank rows which spans two column Named Ranges, "Range1" (A1:A15) "Range2" (D1:D15). As an example:

Beginning with this:

...A......D

1.Text
2........Text
3.
4.
5.
6.Text
7.Text
8.
9.
10.......Text
11.Text
12.
13.......Text
14.
15.......Text

To this , after hiding blanks:
...A......D

1.Text
2........Text
6.Text
7.Text
10.......Text
11.Text
13.......Text
15.......Text

View 2 Replies View Related

VBA Script To Hide And Unhide Specific Columns Within A Worksheet

Oct 24, 2006

Need the VBA script to hide/unhide specific columns within a worksheet.

View 9 Replies View Related

Show/Hide Specific Columns For Custom Views

Jun 12, 2008

I have a spreadsheet with four columns of data for every month (i.e. January has a Prior Year, Budget, Outlook, and Actual column). I have been trying to come up with a macro or form that will allow me to customize which columns I would like to see and hide the rest. For example, if I chose to see the Budget and Actual columns, it would hide the Prior Year and Outlook columns for each month.

View 2 Replies View Related

Excel 2010 :: Using Multiple Checkboxes To Hide And Show Specific Columns

May 12, 2014

Basically I have a big table containing several columns for the different quarters. (Each quarter has several columns which are not all next to each other)

I would like to use 4 checkboxes which the user can select the show or hide the columns for that quarter. E.g. if Q1 and Q3 are checked only those are visible)

(if quarter 1 clicked than all columns are visible if unclicked hidden).

The code I have written workes well for the first checkbox (Q1), but for the other quarters (Q2, Q3 and Q4) the columns get hidden when checked (which should be the other way round) and don't get unhidden when unchecked.

Sub CheckboxQone()
If Range("$A$1").Value = True Then
Call showQ1
Else: Range("$A$1").Value = False
Call hideQ1

[Code] ...........

View 2 Replies View Related

Identify Which Rows Have Blank Values In Specific Columns?

Feb 19, 2013

I have a spreadsheet with columns and columns of data. What I'd like to do is identify which rows have blank/no data in all specified columns (H, K, O, S, U, W, and Y).

To clarify, I need to identify each row where all of these columns are blank (as opposed to each row where at least 1 column is blank).

View 3 Replies View Related

Hide Row If 3 Cell In Column Is Blank In Pivot?

Jul 11, 2013

I want to hide the rows if 3 cells in column B to E is empty (see Result)

Original Table

A
B
C
D

[Code]....

View 9 Replies View Related

Hide Blank Cell Pivot Table

Feb 20, 2010

I'm using pivot table and i want to erase the blank cell that come out with pivot table and replace it with number 0 or -, how can i do that ? i've be try to do this by go to the table option and in the empty cells check list i've put 0 or - but the pivot table still come out "blank".

View 8 Replies View Related

Hide Formula And Leave Cell Blank?

Mar 31, 2013

I am creating a worksheet for my buisness and I have input date of birth and have done a formula to work out ages but I dont know how to hide the formula and leave the cell blank so that when I create new information it automatically puts the age in.

View 1 Replies View Related

Hide Rows In Table If Cell Is Blank?

Mar 9, 2014

I'm trying to create a table that adjusts dynamically to how many cells in a row have text in them. In other words, when a cell is left blank, the entire row should not appear in the table.

I've tried the following code:

Sub test()
Dim i As Integer
Dim nrrows As Integer

[Code]....

When I run this code, it hides all rows, even the ones that aren't blank. why this might happen and how I can make it work?

View 9 Replies View Related

Hide Rows Based On Value In Specific Cell

Apr 8, 2008

Cell A1 can be left blank or have any value 1 to 99999 inserted by the user. Default value is null. My data starts on row 5 and currently goes to row 62, but will include more rows over time. I want to automatically hide rows 5 to 62 (and higher later on) where the value in Column C (C5, C6, C7, etc) is less than or equal to the value in A1 as long as A1 isn't null. If A1 is null, then no row hiding would be done. Ideally would be great to have msg also that says "No rows hidden" or "10 rows hidden", but not critical - just nice to have if you can provide such easily and quickly otherwise I'll just try to learn it later on.

View 7 Replies View Related

Hide Content Of Cell So It Appears Blank To User?

Jan 26, 2014

I would like to hide the content of a cell so it appears blank to user. I edit excel bike tour (route) cue sheets for our bicycle club and some info is needed for formulas in calculating total distance but doesn't need to be seen by the bicycle rider.

View 5 Replies View Related

Hide Multiple Rows Based On Cell Value Being Blank

Feb 20, 2013

I have a worksheet that contains 15 instances of a repeated table over 700 rows. Each table is 45 rows in size and is housed in between the natural page breaks in the spreadsheet.

These tables are populated from data form another worksheet but may not all be used (8 out of the 15 may be used but will always start from table 1 and there will be no missed tables).

In the very top right of the table is a cell value that is only displayed if the table is in use, so will be blank if not used.

Code that will hide multiple rows (45) based on a cell value being blank.

View 2 Replies View Related

Hide Specific Rows When Certain Value Chosen From Cell Drop-Down

Feb 22, 2009

Basicly I used conditional formatting and lots of "IF".My solution lacks in style and it's time consuming ..

Long story short: I need to modify the way some cells are displayed based on the selection in a specific dropdown list.

I need that whenI select Task3 from the dropdown list next to "step1: please select" , everything from row 15 to row21 (both 15 & 21 rows included) and from row 23 on, to disappear.

View 9 Replies View Related

Hide Specific Rows In Sheet1 And Hide 5 More In Sheet2?

May 26, 2014

I have a macro in which i can enter the rows i want to hide.

If i want to hide "position 32" i have to enter the number 8 of the row. This works fine. But now if i want to hide the "position 32" from Sheet1 it also should hide the rows 4-8 from Sheet2 [Data with 32].

Or if i hide "position 34" in Sheet1 [row 10] it also should hide the rows 14-18 in Sheet2.

View 14 Replies View Related

VBA - Delete Row Where Specific Cell Is Blank

Aug 30, 2012

I have written such loop which I want to delete entire row when a given cell is empty:

Code:
lastrow = Cells(Rows.Count, "A").End(xlUp).Row
For Counter = lastrow To 2 Step -1
If Cells(Counter, 6).Value = "" Then
Selection.Rows(Counter).EntireRow.Delete
End If
Next

It works not the way I want. It has ommited some blank rows and also removes 5th row everytime I run it.

View 3 Replies View Related

Populate First Blank Cell In Row With Specific Text Value?

May 28, 2014

I am trying to use VBA to populate the first blank cell in row 6 with the word "Short"

I keep getting sub or function not defined and I am sure its because I am trying to Frankenstein some code together to get it to work. So far everything works as I need but this last step.

View 1 Replies View Related

Entering Data In 1st Blank Cell In Specific Row

Mar 5, 2014

I have created a form where a date and remark is added every few days. I am using Phone Number as the base of VLookup. I want a code so that the date and remark which is entered in a Text Box, is stored in the first available blank cell pertaining to that employee. I want the first date and remark to be under "Date 1" and "Remark 1".

Thereafter, if another remark is subsequently added for that employee, the form would ask to enter his phone number to identify which employee the remark pertains to. Then the Text Box where remark is entered should be stored under "Remark 1" if there has been no remark before, "Remark 2" if "Remark 1" already exists, "Remark 3" if "Remark 2" already exists and so on.

I do not want to enter it in a new row. I want to enter the remark in the next blank cell of the row which matches the employee Phone Number.

Untitled.png

View 5 Replies View Related

How To Insert Blank Row Below A Cell Containing Specific Text

Oct 19, 2009

I was wondering if someone might be able to assist me with using VB to insert a new row below a cell containing specific text.

For example:


- All of my data is in column A

-I want to scan all of column A, and if there is a cell that contains "ACHCAMERIGROUP M", then I want a blank row inserted below it. If column A does NOT contain that text....do nothing.

View 5 Replies View Related

How To Merge Two Rows If Specific Cell Is Blank

Apr 4, 2012

I'm trying to figure out the if conditions for this relatively simple problem. Basically, this is an import from a word document where the table strays onto a new page. I want to try and repair this with a bit of VBA.

This is what it looks like:

1: cell 1 |the content should all be in this cell
2: |but the import sometimes splits it into two
3: cell 2 |

Basically if and only if cell Ax is blank (in this example A2), then I want the rows to merge each cell and repair the table.

View 1 Replies View Related

Hide Columns With VBA When Cell Value Changes

Feb 27, 2009

I have a list of 24 columns (12 months each for forecast and actual data). I want to put VBA code in the worksheet that will hide a column based on a cell value in each column. On line 4 there is a formula that returns either "show" or "no". The columns are AS:BP. The code needs to run on a change in any of the cells AS4:BP4.

View 9 Replies View Related

Hide Columns If Cell In Row Is Zero

Mar 28, 2008

I need a macro to go through and look at each column between and including E to AW. If it sees a 0 in the cell in row 1 then I want it to hide that column completely and go to the next column.

View 8 Replies View Related

Hide Columns With Zero In 1st Cell

Jun 20, 2008

Im wondering is ther any possibility to filter colums. My sheet is having column headings as 1's and 0's .Columns with '0' as heading are to be hidden ..can i add any filter.

View 2 Replies View Related

Putting Specific Value In Blank Cells In Same Row Based On Value In 1st Cell?

Jul 18, 2013

i am trying to Put a specific value i,e "NO Deliveries" in blank Cells in the same row based on value in 1st cell of the Row which has a fixed value . note:the columns and rows are dynamic for example: I want to put the value "no Deliveries" in cell C because its blank.

A B C D

% of Availability
0.00%

80.00%

View 9 Replies View Related

Add Stipulation That Specific Cell Must Not Be Blank To Existing Code

Oct 21, 2013

I have a code now that in excel, when the button is clicked, will put file into a new email and format the email.

What I have been trying to do, is make it so that if Cell C10 is blank, you get a prompt telling you it must be filled out before you can proceed with the submission.

Here is the code now:

Sub SendTimeCard()
On Error GoTo err_handler
Dim OutApp As Object
Dim OutMail As Object

Dim subject As String
Dim body As String
' Be sure the workbook is saved first
ThisWorkbook.Save

[Code] ........

View 2 Replies View Related

Excluding Rows Containing A Specific Blank Cell From Logic

May 1, 2006

how to exclude a blanck cell from logic?

I have tried what you see below but neither works as desired.

If Not vData(n, 9) = 0 Then

If Not vData(n, 9)Is null Then

have corrected code error

View 9 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved