You don't totally clarify, but I will make an assumption. I will assume you
make entries in L2 and M2 and when you change the value in M2, you want the
values in L2 and M2 recorded as constants (4 times) in sheet2

right click on sheet1 and paste in code like this

Private Sub Worksheet_Change(ByVal Target As Range)
Dim rng As Range

If Target.Count 1 Then Exit Sub
If Target.Address = "$M$2" Then
With Worksheets("Sheet2")
If IsEmpty(.Range("L2")) Then
Set rng = .Range("L2")
Else
Set rng = .Cells(Rows.Count, "L").End(xlUp)(2)
End If
End With
rng.Resize(4, 1).Value = Me.Range("L2")
rng.Offset(0, 1).Resize(4, 1) = Target
End If

End Sub


Always enter in L2 first, then M2

--
Regards,
Tom Ogilvy


"Matt G " wrote in message
...
Hi Tom, Thanks for your response. You were able to articulate what I
was trying to in my original post.

My desired reult is to have my entries from Sheet 1 progress down
columns L and M duplicating in 4 instances

I have been trying variations of a vlookup to make this work a few
minutes ago and still have had no success. I will keep trying.

Thanks again,
Matt


---
Message posted from http://www.ExcelForum.com/