Excel question

Closed
Posts
1
Registration date
Thursday January 28, 2010
Status
Member
Last seen
January 29, 2010
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,
I am trying to create a form based on the last row of information on a separate worksheet. I would like for this form to automatically update once new information is entered and the last row has changed.

For example say i have a spreadsheet with 20 rows of data, I want the form to pull data from row 20. When I enter data in row 21 I would like for the form to automatically update with data from row 21.

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
You left out a lot, so I for one am not sure how your form is designed. How ever, perhaps you would find your answer by using the routine

Private Sub Worksheet_Change(ByVal Target As Range)

End Sub

This routine you would define in the sheet based on which you have created that form.