+ Reply to Thread
Results 1 to 3 of 3

Auto Summing left within borders

  1. #1
    Registered User
    Join Date
    01-29-2016
    Location
    Toronto,Canada
    MS-Off Ver
    Office 2007
    Posts
    6

    Auto Summing left within borders

    Hello,
    as titled states, is there a way to auto sum everything on the left ? These are borders and not tables.
    Something like this
    Untitled.png

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,900

    Re: Auto Summing left within borders

    I'm not much use with VBA. However, I don't see how this can be done - even with VBA. The nearest I do is a UDF that sums all cells in a range with FULL borders. Put the code in a module in the sheet (right click on sheet name/view code/INSERT/MODULE and save as Excel enabled.

    Please Login or Register  to view this content.
    I know this isn't quite what you asked for, but I don't know how Excel could differentiate between the two green-shaded cells in the attached file, if only the outer borders were present. Both cells would then have a border top & left. Maybe someone else will do it exactly as you require...
    Attached Files Attached Files
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  3. #3
    Registered User
    Join Date
    01-29-2016
    Location
    Toronto,Canada
    MS-Off Ver
    Office 2007
    Posts
    6

    Re: Auto Summing left within borders

    I'll give this a try

    Thank you!

+ 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. Summing cells to left of formula
    By Mavbohs in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-13-2015, 11:58 AM
  2. [SOLVED] Auto change borders to thick borders
    By Pierce Quality in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 11-22-2013, 11:17 PM
  3. Summing row values ONLY to the left of a row, not the right..
    By josheeeee in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-05-2013, 09:21 PM
  4. [SOLVED] How to hide cell reference borders (top/left side) in Excel?
    By jwe06 in forum Excel General
    Replies: 1
    Last Post: 08-03-2006, 11:45 AM
  5. Auto Borders
    By Mike in forum Excel General
    Replies: 0
    Last Post: 02-01-2006, 02:30 PM
  6. top/left cell borders don't show
    By km in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-24-2005, 05:06 PM
  7. Cell borders & repeat columns at left re: printing
    By William DeLeo in forum Excel General
    Replies: 0
    Last Post: 03-23-2005, 10:40 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