Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Display column when previous column contains data
The problem I have is that I have 10 years worth of data in 10 columns
and then 20 empty columns after those awaiting data entry (for the next 20 years). I was wondering if it was possible to hide these columns, leaving only one empty column. When the header for this empty column (the year) is filled in, I want the next empty column to be displayed. Does anyone know if this is possible? (the columns contain many formulas and are also called upon by other sheets.) Thank you very much in advance if you can help!!! Matt |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Display column when previous column contains data
Right click sheet tabview codeinsert thissave
Private Sub Worksheet_Change(ByVal Target As Range) If Target.Row < 1 Then Exit Sub If Len(Target) 1 Then _ Columns(Target.Column + 1).Hidden = False End If End Sub However, you might consider adding the formulas by macro as each year is needed. Much less overhead. You could also then change the preceeding formulas to values for the same reason. -- Don Guillett SalesAid Software wrote in message oups.com... The problem I have is that I have 10 years worth of data in 10 columns and then 20 empty columns after those awaiting data entry (for the next 20 years). I was wondering if it was possible to hide these columns, leaving only one empty column. When the header for this empty column (the year) is filled in, I want the next empty column to be displayed. Does anyone know if this is possible? (the columns contain many formulas and are also called upon by other sheets.) Thank you very much in advance if you can help!!! Matt |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Based on data in previous column - sum of values in next column | Excel Worksheet Functions | |||
Shortcut to select column with data in previous column | Excel Discussion (Misc queries) | |||
Based on a condition in one column, search for a year in another column, and display data from another column in the same row look | Excel Programming | |||
Based on a condition in one column, search for a year in another column, and display data from another column in the same row look | Excel Discussion (Misc queries) | |||
Copying a formula in a blank column as far as data in previous column | Excel Programming |