Have the cells of a form in Excel auto populate

[karizito]

Hi all,

I am trying to do something like this:

I had put 2 sheets in the same workbook, when I receive new information, I will add a new row of data to the 1st sheet. My 2nd sheet is a form that I will print out after all info has been entered. What I want to do is I want to have the fields on my 2nd sheet to auto populate whenever I update the 1st sheet. I know how to link cells between worksheets, what I am not sure about in this case is I am not linking the cell in 2nd sheet to a specific cell in 1st sheet. Since I will be adding new row when I receive new information, the same cell in 2nd sheet will link to the cell one row below everytime I add new information. Can someone please shed some light?


Thanks a lot!!

 

[Trevor G]

Would something like this help if you run it form a command button on the first sheet?

Sub CopyToSheet2()
Application.ScreenUpdating = False
ActiveCell.EntireRow.Copy
Sheets("Sheet2").Activate
Range("a1").Select
Do Until ActiveCell.Value = ""
ActiveCell.Offset(1, 0).Select
Loop
ActiveCell.EntireRow.PasteSpecial xlPasteAll
Sheets("Sheet1").Activate
Application.CutCopyMode = False
Application.ScreenUpdating = True
End Sub

 

[karizito]

Thanks a lot Trevor for answering my question. However, I am not very advance in Excel so I am not sure how to perform the step. Is there an easier way to do it? Thanks again!