HELP me pleeeeease

[bql83i]

Okay, I need to link the contents of the cells in the last completed row of sheet 1 to specific cells sheets 2 and 3.

for example contents of cell a20 row 20 sheet 1, into cell 5 column c sheet 2 and cell 4 in column f sheet 3.

I'm using Office 2007

 

[Tuelor]

Try the following (editing as appropriate)

=OFFSET(A1,COUNTA(A:A)-1,0)

 

[bql83i]

Try the following (editing as appropriate)

=OFFSET(A1,COUNTA(A:A)-1,0)

Hi Tuelor, due to a very long illness, now fully recovered, a long overdue thankyou for your help it resolved my issue perfectly.