Results 1 to 9 of 9

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

Threaded View

  1. #1
    Registered User
    Join Date
    04-15-2012
    Location
    Louisville, KY
    MS-Off Ver
    Excel 2007
    Posts
    15

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

    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
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1