last used row in column C equals last used row in column E

[FROGGER24]

Hello everyone, I could use some help in finding last used rows. If C1 is >0, I need the last used row in column C to equal last used row in column E.

thanks

 

[shknbk2]

When do you want this to happen? Automatically whenever the value in C1 changes?

Let's say that C1 > 0 and that column C uses rows 1-15 and column E uses 1-10, do you simply want to delete C11-C15?

What if C uses rows 1-5? Do you want to add values to C6-C10?

 

[FROGGER24]

if I understand your question correctly, the columns will be the same length

 

[shknbk2]

Are you asking to make sure that if C1 > 0, then set the value of C10 the same as E10 (assuming that these are the last cells in the columns)?

 

[FROGGER24]

that is correct

 

[shknbk2]

Put this in the worksheet's code area.

Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Address = "$C$1" Then
        If Target.Value > 0 Then
            Cells(Rows.Count, 3).End(xlUp).Value = Cells(Rows.Count, 5).End(xlUp).Value
        End If
    End If
End Sub

 

[FROGGER24]

thank you, the code worked fine.

 

[FROGGER24]

can the code be modified so it is a regular formula versus worksheet change event?

 

[FROGGER24]

i think the formula should look like this in B1 =if($C$1=0,c1&lr,(C1&LR =E1&lr)

 

[shknbk2]

I don't know what your values are in columns C & E, but to have a formula control the values, the cells in C have to be formulas.