Results 1 to 4 of 4

VBA To Capture Values From Cells

Threaded View

  1. 03-23-2017, 09:38 AM #1
    jo15765
    jo15765 is offline
    Forum Contributor
    Join Date
    06-18-2010
    Location
    USA
    MS-Off Ver
    Excel 2016
    Posts
    546

    VBA To Capture Values From Cells

    I am in need of a way to filter a worksheet then sum one column, and capture the first non 0 or null value for another. I have spent hours working on this and am unable to get the syntax exactly right. I have attached a sample workbook with sample data and set-up, and the VBA that I have tried.

    How should code be altered so that my desired value is returned?
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Input a value and capture the next 5 values
    By danallamas in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-18-2016, 09:07 PM
  2. Macro to capture values from web
    By Rockafella in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-14-2012, 09:28 AM
  3. Capture values from active IE page
    By rkb in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-19-2011, 12:19 AM
  4. Formula to capture values from one sheet to another
    By yuzi in forum Excel General
    Replies: 17
    Last Post: 11-30-2009, 05:21 PM
  5. Ontime to capture cells values at a giving time
    By erickguz in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-22-2007, 01:33 AM
  6. capture unique values and calculate
    By bcamp1973 in forum Excel General
    Replies: 4
    Last Post: 05-15-2006, 01:06 PM
  7. RE: 'IF' FORMULA TO CAPTURE CERTAIN CELL VALUES
    By JMB in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-26-2006, 06:55 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1