Previous Topic Next Topic

Excel question

Closed
eec Posts 1 Registration date Thursday 28 January 2010 Status Member Last seen 29 January 2010 - 29 Jan 2010 à 14:39
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 29 Jan 2010 à 20:12
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

Réponse 1 / 1
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
29 Jan 2010 à 20:12
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.

Similar discussions

My account locked connect to gemail
Karthik -
winko -

2 responses
Keyboard troubles
jimbobjoe -
car -

38 responses
Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses