Previous Topic Next Topic

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

Answer 1 / 1
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

Similar discussions

Keyboard troubles
jimbobjoe -
car -

38 responses
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

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

11 responses