+ Reply to Thread
Results 1 to 7 of 7

sort out specific entries from Bank statement

  1. #1
    Registered User
    Join Date
    12-07-2009
    Location
    Heaven
    MS-Off Ver
    Excel 2003 and 2007
    Posts
    69

    sort out specific entries from Bank statement

    Hi,

    I want to extract specific entries from the bank statement to copy them and paste on a separate excel sheet. How can i do this? This I need to do for a specific bill payments has been made. Thanks for your kindly effort.
    Attached Files Attached Files
    Last edited by top1; 04-16-2010 at 07:05 PM. Reason: attach a excel file

  2. #2
    Forum Contributor
    Join Date
    04-23-2009
    Location
    Dublin, Ireland
    MS-Off Ver
    Excel 2003 work, 2007 home
    Posts
    199

    Re: sort out specific entries from Bank statement

    what discerns the entries you want to extract from the rest of the chaff? once we know this we can help you....

  3. #3
    Registered User
    Join Date
    12-07-2009
    Location
    Heaven
    MS-Off Ver
    Excel 2003 and 2007
    Posts
    69

    Re: sort out specific entries from Bank statement

    i attached a sample file. this is just as examples hope it helps you to understand my question. thanks

  4. #4
    Forum Contributor
    Join Date
    04-23-2009
    Location
    Dublin, Ireland
    MS-Off Ver
    Excel 2003 work, 2007 home
    Posts
    199

    Re: sort out specific entries from Bank statement

    can you put a filter (data-filter..2007) on to see the specific data you need?

  5. #5
    Registered User
    Join Date
    12-07-2009
    Location
    Heaven
    MS-Off Ver
    Excel 2003 and 2007
    Posts
    69

    Re: sort out specific entries from Bank statement

    i have really very basic idea of excel.. how can i do tht i have office 2007. thansk

  6. #6
    Forum Contributor
    Join Date
    04-23-2009
    Location
    Dublin, Ireland
    MS-Off Ver
    Excel 2003 work, 2007 home
    Posts
    199

    Re: sort out specific entries from Bank statement

    data -filter- deselect all (will clear out the defaults)- select what you want to keep
    Last edited by somesoldiers; 04-16-2010 at 08:43 PM.

  7. #7
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,475

    Re: sort out specific entries from Bank statement

    Here you go,
    Should work with '07 as well. It is macro driven so enable macros when you open it.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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