ausnewexcel
New Member
- Joined
- Jul 1, 2008
- Messages
- 1
I have a number worksheets to which data is added to the next free cell in columns as time moves on.
On the summary page I would like to insert a formula that returns the contents of the last cell before a blank cell from the columns so that is shows the latest entry.
Is there a standard formula without having to use VBA that can be used?
Thanks
On the summary page I would like to insert a formula that returns the contents of the last cell before a blank cell from the columns so that is shows the latest entry.
Is there a standard formula without having to use VBA that can be used?
Thanks