+ Reply to Thread
Results 1 to 3 of 3

VBA to find and Sum the column

  1. #1
    Forum Contributor
    Join Date
    07-17-2012
    Location
    India
    MS-Off Ver
    Excel 2016
    Posts
    713

    VBA to find and Sum the column

    Hi,

    Macro recorder helped me to get the below code.

    Please Login or Register  to view this content.
    Please help on as how can i make the sum value dynamic. As not necessary it will be on I24 always be.
    Keep the Forum clean :


    1. Use [ code ] code tags [ /code ]. It keeps posts clean, easy-to-read, and maintains VBA formatting.
    2. Show appreciation to those who have helped you by clicking * Add Reputation below their posts.
    3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.

  2. #2
    Forum Contributor
    Join Date
    07-17-2012
    Location
    India
    MS-Off Ver
    Excel 2016
    Posts
    713

    Re: VBA to find and Sum the column

    Ok, below code works for top to below.

    Please Login or Register  to view this content.
    But how to modify it to get below to up? Because another total i need to do is to sum from last cell value until up ( which is at I25). Kind of xlup function
    Last edited by shiva_reshs; 10-03-2018 at 07:26 AM.

  3. #3
    Forum Contributor
    Join Date
    07-17-2012
    Location
    India
    MS-Off Ver
    Excel 2016
    Posts
    713

    Re: VBA to find and Sum the column

    Finally got it down to below code.

    Please Login or Register  to view this content.
    Thanks all

+ 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 keyword in column B and print vaue of column E to column G not working
    By moorea21 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-30-2017, 04:58 AM
  2. Replies: 2
    Last Post: 05-23-2017, 08:28 AM
  3. Loop through column to find EID then find date and paste corresponding data
    By CieloSalas in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-01-2017, 06:33 PM
  4. Replies: 3
    Last Post: 11-25-2014, 06:08 AM
  5. Replies: 3
    Last Post: 05-28-2014, 12:01 PM
  6. Replies: 2
    Last Post: 04-26-2013, 01:16 PM
  7. 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

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