Automatically populate data

[Kyle CP]

Hi,

I want data to populate on "sheet 2", from "sheet 1". That means that when I insert a new row in "sheet 1", I want "sheet 2" to display the data that has been entered into the newly inserted row on "sheet 1", without having to re-enter the formulas in "sheet 2". I'm fairly macro - unsavvy. Is there a non-macro solution, or an easy macro solution for this?

Any help much appreciated.

Regards,

Kyle

 

[VoG]

Hello. What is the last column to be populated = assuming that data is entered left to right?

 

[Kyle CP]

Column N is the last column, but I'd like to be able to enter rows at any point in the sheet. Does that make sense?

Kyle

 

[VoG]

Try this: right click Sheet1's tab, select View Code and paste in

Private Sub Worksheet_Change(ByVal Target As Range)
If WorksheetFunction.CountA(Target.EntireRow) = 14 Then
    Target.EntireRow.Copy Destination:=Sheets("Sheet2").Range("A" & Rows.Count).End(xlUp).Offset(1)
End If
End Sub

 

[Kyle CP]

Excellent, thanks VOG.

Kyle