Search results for query: *

Thank you very much for all your help. The INDEX feature worked well.

Thank you all for all your help.

It keeps giving me 0 and when I change the cell type to date it always gives me 1/0/1900.

So should it be =OFFSET(Sheet2!A1,COUNTA(Sheet2!F:F)+8,5) instead of =OFFSET(Sheet2!A1,COUNTA(Sheet2!F:F)+7,5)

The header starts from B7-F7. So the data starts on row 8. So there is "data" above F8 but nothing important. Thank you all once again.

I've tried the offset formula but it just returns 1/0/1900. When it the last cell in column F has 8/12/10. I forgot to mention that the data starts on F8 and continues on down.

I need to know what is in the last cell in column F. So if i add another row, the next last cell in column F keeps showing up. Thanks

Hi all and thanks for helping out. I need to have a cell on Sheet1 keep referencing the latest cell of column F Sheet2. So as the worksheet grows,I know the what the latest information on the other worksheet is. Thanks again.