Paulasirius
New Member
- Joined
- Feb 23, 2002
- Messages
- 8
I have a financial spreadsheet in Microsoft Excel 97 which contains several worksheets. I am trying to create a formula on a summaries worksheet that will locate the last entry in a payments column on another worksheet containing dates, items and payments. There seems to be no function for referencing a cell that is the last one entered in a column. If I can find a way to do this, I can then use a lookup reference function to copy the date into the summaries worksheet as well. Does anyone know what is the usual way of dealing with this type of referencing?