How to go to last specified column entry on Lotus 123 spreadsheet

Hello. Ok I'm a dinosaur, still using Lotus 123 and on Windows7! But it works well for me. Maybe someone out there can help please?

So I use spreadsheets a lot and one thing that eludes me is how to pick up the last entry in a particular column and include it in another spreadsheet. I do this successfuly for other data for which I can find and use the appropriate @ function. Anybody please?

Sorry I didn't respond sooner but just came across your message.

I can't remember using this in any of my spreadsheets (never had the need as I use MACRO statements to link with), but I believe the @ function you're looking for is @DATALINK.

(From the help file for @DATALINK)

@DATALINK(app-name;topic-name;item-name;[format];[max-rows];[max-cols];[max-sheets]) creates a DDE link to data.
You can change the link by changing the @DATALINK arguments.

Arguments

app-name is text that specifies the name of an open Windows application that supports DDE as a server.
topic-name is text that specifies the name of the application file to link to. Use "system" to link to the system topic. If you are linking to a file, that file must also be open in the server application.
item-name is text that specifies the name of the item in the server application to link to. This is the item in the server application file from which you want to transfer data through the link.

format is an optional argument that specifies one of the Clipboard formats. format is text and can be Text, WK1, or WK3. If you omit format, 1-2-3 uses the Text Clipboard format.
max-rows, max-cols, and max-sheets are optional arguments that specify the maximum number of rows, columns, and sheets for the destination range. If you omit max-rows, max-cols, or max-sheets, 1-2-3 uses as many rows, columns, or sheets as the destination range requires.

You cannot use an optional argument without using the ones that precede it.

Examples

The following @DATALINK formula creates a DDE link to the Word Pro file LOAN.LWP.
@DATALINK("WordPro";"C:\LOTUS\WORK\WORDPRO\LOAN.LWP";"!Link_BookMark1")