Read value from certain line in text file

Hello!

I have a small problem I hope some of you guys/girls migth help me with.

I have a continuously updating textfile. Each (lets say 1 second intervals) a new dataset (of 10 rows) is written into this file, at bottom.

I would like to read (at a click of a button) certain lines counted from bottom of this file, and put theese into a list on a worksheet. '

Lets say row 2 and 3 (from bottom of textfile), is put into A1 and B1.

So that next time I press the button, row 2 and 3 (from bottom of textfile), is put into A2 and B2.


Anyone to help a desperate girl with this? I'm quite lost...

Thank you for answering! But this takes the last two lines, I would like it to read the 2nd and 3rd line from bottom.

Examples:
....
Some text A
Some text B
Some text C
Some text D
Some text E < -- Read this line
Some text F < -- Read this line
Some text G (last line)

I'm not that good to explain, but I hope you understand