Excel question

Closed
eec Posts 1 Registration date Thursday January 28, 2010 Status Member Last seen January 29, 2010 - Jan 29, 2010 at 02:39 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jan 29, 2010 at 08:12 PM
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.
Related:

1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jan 29, 2010 at 08:12 PM
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.
0