Naming cells

[Smoakstack]

I am lost. I have variable data coming into ranges ("c9:c214"). I also have columns that filter this variable data. I cannot however name these columns based on such data. Any ideas? ie. if c9=119, then cell m6 = cell d6.

 

[Mike Blackman]

Are you talking about having a dynamic range that automatically sizes dependant on variable number of rows of data?

 

[Smoakstack]

here is what I have.

Sub hide()
Dim B As Range
Dim c As Range
Application.ScreenUpdating = False
For Each c In Range("M216:NC216")
If (c.Value = 0) Then
c.EntireColumn.Hidden = True
Else
c.EntireColumn.Hidden = False
End If
Next c

For Each B In Range("b9:b214")
If (B.Value = 0) Then
B.EntireRow.Hidden = True
Else
B.EntireRow.Hidden = False
End If
Next B

Application.ScreenUpdating = True
End Sub

This is to hide cells if equal to 0. I need it so that if it equals 1, then cell m6 of range m6z6 = the cell of the contents next to it

 

[Smoakstack]

if b.value = X, then c.text = d.text
X=X+1


something along those lines

 

[Smoakstack]

bump

=IFERROR(VLOOKUP(93,$C$9:$D$214,2,FALSE),0)

figured it out. thank you to other threads.