Always view bottom

[Wouldsman]

Is there a way to have a sheet show the last entry?
I'm filling in a sheet automatically from another sheet and need to have the last set of rows show up on the monitor after it does it auto entry.

[:) Sixthsense :)]

Assume that Sheet2 is your master sheet in which the data will get added continuously...

In A1 Cell of Sheet 1

=LOOKUP(2,1/(Sheet2!A:A<>""),ROW(Sheet2!A:A))

In A2 Cell

=INDEX(Sheet2!A:A,$A$1)

Drag it to right...

So now whenever the data gets added in Sheet2 then the Last entry will reflect in Sheet1 Row 2

[Wouldsman]

Thank you Sixthsense.

I didn't explain myself correctly or enough I'm afraid.
I do want to see the last entry but I also want to see as many of the last row as will fit on the screen at a time.
So in the end I will be looking at say the last 20 or so entries/rows of information.

[:) Sixthsense :)]

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[Wouldsman]

Sorry you didn't understand.
Here are some attachments.
A before and a after.

[Fotis1991]

Perhaps something like this in worksheet module?

Private Sub Worksheet_Activate()
Range("B" & Rows.Count).End(xlUp).Select
End Sub

[:) Sixthsense :)]

Here are some attachments.A before and a after.

I couldn't able to find any difference in the before and after wokbooks

[Wouldsman]

This placed the cursor at the end but did not force the sheet to view the cell it selected.

[Fotis1991]

This placed the cursor at the end but did not force the sheet to view the cell it selected.

But in your title and also in your first sentence you are asking for:

Always view bottom
Is there a way to have a sheet show the last entry?

My code select the last used cell in column B.

[kvsrinivasamurthy]

Pl see attached file.Worksheet_Activate event is used for Sheet2. When Worksheet activated Cursor goes next to last entry. same can be copied to other Sheets.