Find last cell used in column and show data in that cell

[LaurenL]

Hello!
I am new to this and need some help. I imagine that this would be an easy fix but just cant figure it out. I have been looking thourgh threads for hours now. Okay so I am creating a workbook for my boss that shows each customers account. I need to find the last cell in column F which I have done in N2 with this formula:

=ADDRESS(MATCH(1E+30,F:F),COLUMN(F1),)

However, the result gives me the cell reference : $F$6

What I need to do is get the data in that cell (F6) so that I can copy & paste special it into a word doc. (invoice to be mailed to cust). But I need the word doc. to show the data in the last cell in coulmn F. Not just whats in there now. I have attached my spreadsheat so that you can see what Im talking about.

I appreciate any and all help with this matter greatly!

Thank you! LaurenL

[Cutter]

You can use

=INDEX(F4:F5000,COUNT(F4:F5000))

if there are no blank cells between occupied cells. Change the 5000 to something larger if you anticipate the range being more than that.

You could even use

=INDEX(F:F,COUNT(F:F)+3)

[LaurenL]

Thank you very much for your reply! However, Im not able to get this formula to work if the last cell used in Column F changes. I will add something to this column each month and I would like for the cell copy/pasted to reflect the last used cell.

[Cutter]

The formula does exactly that.
Paste the formula you are using in your next reply and describe how it is not working as expected.

[LaurenL]

Sorry abotu the last post. This did work for me! I will need help on another part of this book but I just haven't gotten there yet! I will marked this solved as soon as I fugre this out. Anything that I an do for you since you solved this for me?

Thank you very much!

[Cutter]

You're very welcome. Glad you got it working.

[LaurenL]

When applied to an entire column the last cell with 0 in it is te one that shows. Is there any way to show only the last cell with info in it? I need to extract the last cell with data in it to paste special onto the invoice. As of now it shows that cust owes 0 when i apply it to the enitre row. And as my customers would love to get an invoice that says 0 I would not.

Thanks again!

[Cutter]

Perhaps you could do the COUNT() on the B column (dates). So use:

=INDEX(F:F,COUNT(B:B)+3)

[LaurenL]

Works great. Thanks again!