+ Reply to Thread
Results 1 to 5 of 5

Find last cell in column with sum

  1. #1
    Forum Contributor
    Join Date
    12-14-2005
    Location
    US
    MS-Off Ver
    Excel 2019, Excel 365, Excel Mobile (Android)
    Posts
    145

    Find last cell in column with sum

    I have attached a worksheet for reference. It has some VBA code and worksheet formula. First I import data from a txt file into the DATA sheet. Following I use TRIM macro to reformat the data and enter into DATA2 sheet.
    What I need is to be able to find the last data cell in column I and then in the next cell down SUM the column with a single line border above the cell and a double line border below. I also would like to copy the amount from that cell into cell L15. The copied amount will show if there is any difference between that cell and cell L13.

    As always thank you for any help offered.
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    08-08-2022
    Location
    Buenos Aires
    MS-Off Ver
    Excel 2019
    Posts
    1,777

    Re: Find last cell in column with sum

    Hi. Try with:

    Please Login or Register  to view this content.
    You are always very welcome if you add reputation by clicking the * (bottom left) of each message that has helped you.

  3. #3
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,457

    Re: Find last cell in column with sum

    Thought the structure of the formula and the code looked familiar

    Try:
    Please Login or Register  to view this content.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  4. #4
    Forum Contributor
    Join Date
    12-14-2005
    Location
    US
    MS-Off Ver
    Excel 2019, Excel 365, Excel Mobile (Android)
    Posts
    145

    Re: Find last cell in column with sum

    Trevor, you got me man. You rock on the scripting. As always thanks for your help. Frick

  5. #5
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,457

    Re: Find last cell in column with sum

    You're welcome.


    Not complaining. Happy that you have been able to adopt and adapt my solutions to meet your needs. Just felt kinda weird looking at it and thinking WTF ...

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Find partial values from each cell of column x in column y, then color cell for matches
    By therealdees in forum Excel Programming / VBA / Macros
    Replies: 37
    Last Post: 06-11-2021, 06:47 PM
  2. Replies: 1
    Last Post: 11-20-2019, 10:58 PM
  3. Find 1st unique Value on Column and Insert certain Word on cell on left Column
    By Wldlife23 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-16-2013, 10:02 AM
  4. [SOLVED] Macro to find the empty cell in a column and copy a adjacent row to another column.
    By naga in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-18-2013, 07:44 AM
  5. macro to find first blank cell in a column cut the value from left adjacent column
    By willykin in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-01-2012, 09:23 AM
  6. Range.Find to find column and place value in next available cell in one line
    By davegugg in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-02-2011, 10:41 AM
  7. Replies: 8
    Last Post: 08-06-2009, 09:02 AM

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