Find Last Cell

[aj_walters]

Hi All

This is probably a simple question,

I have a number of sheets that have cash book entries in, what I need to be able to do is find the last entry in the balance column, and transfer this to the next workbook, the problem I have is that some months are busier than others, so the workbook can have any thing from 20 – 150 entries in it !!


Please help

 

[Aladin Akyurek]

On 2002-04-30 05:16, aj_walters wrote:
Hi All

This is probably a simple question,

I have a number of sheets that have cash book entries in, what I need to be able to do is find the last entry in the balance column, and transfer this to the next workbook, the problem I have is that some months are busier than others, so the workbook can have any thing from 20 – 150 entries in it !!


Please help

Supposing that the balance column is E (adjust to suit if not), use:

=INDEX(E:E,MATCH(9.99999999999999E+307,E:E)

will give you the last numeric entry.

 

[aj_walters]

Thanks

 

[sen_edp]

hello

try this

http://www.beyondtechnology.com/geeks012.shtml

Andreas