+ Reply to Thread
Results 1 to 6 of 6

Extract certain entries and returns value to a new worksheet with running balance

  1. 10-21-2016, 01:23 PM #1
    NESSTY is offline
    Registered User
    Join Date
    06-17-2016
    Location
    new york, ny
    MS-Off Ver
    2003
    Posts
    5

    Extract certain entries and returns value to a new worksheet with running balance

    Hi All,

    I need a function that would extract all "savings" entry from a bank register (checking acct) worksheet to another bank register (savings acct) with a running balance so that i don't have to do make another entry to keep track of the savings deposits.
    Reply With QuoteRegister To Reply
  2. 10-21-2016, 01:35 PM #2
    Tony Valko is offline
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Extract certain entries and returns value to a new worksheet with running balance

    Post some sample data and show us what result you expect.
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.
    Reply With QuoteRegister To Reply
  3. 10-21-2016, 02:53 PM #3
    NESSTY is offline
    Registered User
    Join Date
    06-17-2016
    Location
    new york, ny
    MS-Off Ver
    2003
    Posts
    5

    Re: Extract certain entries and returns value to a new worksheet with running balance

    i want savings worksheet to pick up all "AMEX SAVINGS" transactions as they are entered in the checking worksheet.

    1.pdf
    Reply With QuoteRegister To Reply
  4. 10-21-2016, 03:55 PM #4
    Tony Valko is offline
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Extract certain entries and returns value to a new worksheet with running balance

    Can you post the data in an Excel file?
    Reply With QuoteRegister To Reply
  5. 10-21-2016, 04:10 PM #5
    NESSTY is offline
    Registered User
    Join Date
    06-17-2016
    Location
    new york, ny
    MS-Off Ver
    2003
    Posts
    5

    Re: Extract certain entries and returns value to a new worksheet with running balance

    i would like all "AMEX SAVINGS" entry to automatically populate to sheet 2 as it is entered in sheet 1 and have a running balance.Attachment 485819
    Reply With QuoteRegister To Reply
  6. 10-21-2016, 04:51 PM #6
    Tony Valko is offline
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Extract certain entries and returns value to a new worksheet with running balance

    When I try to download the Excel file I get this message:

    vBulletin Message

    Invalid Attachment specified. If you followed a valid link, please notify the administrator
    Reply With QuoteRegister To Reply
+ Reply to Thread
« 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. How do i get the running balance from one worksheet to another?
    By bj in forum Excel Formulas & Functions
    Replies: 24
    Last Post: 09-06-2005, 07:05 PM
  2. How do i get the running balance from one worksheet to another?
    By Spoardy in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 PM
  3. How do i get the running balance from one worksheet to another?
    By bj in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 09-06-2005, 07:05 AM
  4. How do i get the running balance from one worksheet to another?
    By Spoardy in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 AM
  5. [SOLVED] How do i get the running balance from one worksheet to another?
    By Spoardy in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 01:05 AM
  6. How do i get the running balance from one worksheet to another?
    By Spoardy in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 AM
  7. How do i get the running balance from one worksheet to another?
    By Spoardy in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 11:05 PM
  8. How do i get the running balance from one worksheet to another?
    By Spoardy in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-02-2005, 04:05 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