+ Reply to Thread
Results 1 to 4 of 4

Summarise data in one sheet from multiple sheets

  1. #1
    Forum Contributor
    Join Date
    05-14-2010
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    155

    Summarise data in one sheet from multiple sheets

    Dear Experts,

    I need a help regarding below query: -

    I have a workbook, where in 3 different sheet, i am updating daily bank transaction of all three accounts and i want a combine data sheet (with selective column) from all the three accounts.

    In the attached file there are three worksheet e. g. Account-1, Account-2 & Account-3. in the fourth sheet i have coppied manually data and i want it should update automatically when data edit/update in any of account worksheet.

    Please look into the matter and do the needful.

    Thanks in advance.
    Attached Files Attached Files
    Rajeev Kumar

  2. #2
    Valued Forum Contributor ImranBhatti's Avatar
    Join Date
    03-27-2014
    Location
    Rawalpindi,Pakistan
    MS-Off Ver
    Office 365
    Posts
    1,784

    Re: Summarise data in one sheet from multiple sheets

    Insert this code in Thisworkbook code modual. Then edit every sheet will be recorded on your "Summary" sheet.

    Please Login or Register  to view this content.
    Last edited by ImranBhatti; 08-20-2018 at 02:32 PM.
    Teach me Excel VBA

  3. #3
    Forum Contributor
    Join Date
    05-14-2010
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    155

    Re: Summarise data in one sheet from multiple sheets

    Hi,
    Thanks for your reply.
    Given code is not working

  4. #4
    Valued Forum Contributor ImranBhatti's Avatar
    Join Date
    03-27-2014
    Location
    Rawalpindi,Pakistan
    MS-Off Ver
    Office 365
    Posts
    1,784

    Re: Summarise data in one sheet from multiple sheets

    Hi Raj

    It is working for me. Please test the attached.
    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)

Similar Threads

  1. Replies: 2
    Last Post: 12-26-2016, 12:37 PM
  2. Summarise multiple sheets into master sheet: text, numbers
    By smellodeee in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-19-2016, 08:24 AM
  3. Summarise multiple sheets
    By dreams1 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-11-2013, 04:53 PM
  4. [SOLVED] How to summarise 9 sheets into sheet 1
    By leanne2011 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-14-2012, 04:44 AM
  5. Summarise Multiple Sheets
    By thatitalian in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 04-10-2012, 06:23 AM
  6. Summarise data from multiple sheets based on dates
    By tanktata in forum Excel General
    Replies: 4
    Last Post: 02-21-2012, 02:54 PM
  7. Replies: 2
    Last Post: 09-22-2010, 10:48 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