Display column when previous column contains data

  • Thread starter Thread starter MPSingley
  • Start date Start date
M

MPSingley

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
 
Right click sheet tab>view code>insert this>save

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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hiding column if cell in previous column is empty-revised 2
A data validation question 1
To determine if selection range contains empty rows 3
OFFSET LOOKUP function in VBA? 9
finding groups of empty cells in a column 4
Hide column based on data validation 0
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
VBA - retrieve data on last create named range from previous inserted named range 0

Back
Top