Find the last entry on a sheet?

  • Thread starter Thread starter Paul Watkins
  • Start date Start date
P

Paul Watkins

Hi
I need some help with the following.
I Have a workbook with 2 sheets (Entry & Result). On the 'Entry' sheet i
have various people inputing requests cell by cell. e.g:

Person 1 enters request into cell A1
Person 2 enters request into cell A2
Person 3 enters request into cell A3 and so on.

I want then, the 'Result' sheet -Cell B6 always to display the last entered
request on the 'Entry' sheet, which could be A3, A4 or A100 etc...
How do i do this?


Thanks in advance

Paul
 
Thanks for the reply.
I tried a demo sheet with the following:-

Cell A1 = Test1
Cell A2 = Test2
Cell A3 = Test3
but all it gives me is the value in cell A1 (Test1) all the time.
What i need is to display the last entry input into column A which in the
example above would be 'Test3' but that might also be A34 or A67 for
example.

Paul
 
The formula works. I'm not sure what's causing the issue
you're having. Email me your file and I'll take a look at
it.
Jason
 
Sorry Jason, it was my fault, it was conflicting with some sheet vb code
It is working now
Thanks again


Paul
 
Hi, Paul.

Jason's line should work just fine (it does for me).
Be sure to check that you have automatic calcuation
turned on (Tools->Options->Calculations) or hit F9.
(Note you'll get a zero if any row (like A34)is blank)

BTW if the values were entered 'across' the sheet,
say always in row 3, the formula should be changed
by substituting 3 for A.

HTH.
jeff
 
Hi
........>>>(Note you'll get a zero if any row (like A34)is blank)...........
How do you get around this problem with the formula........
=INDEX(Entry!A:A,COUNTA(Entry!A:A))

Paul
 
Back
Top