+ Reply to Thread
Results 1 to 16 of 16

Urgent Help on Summary consolidation from different sheets for particular date

  1. #1
    Registered User
    Join Date
    04-30-2014
    Location
    india
    MS-Off Ver
    Excel 2010
    Posts
    18

    Urgent Help on Summary consolidation from different sheets for particular date

    Dear Experts,

    I have multiple sheets having same column headers and number but number of rows change for each sheet. I need summary sheet on particular date to be extracted from multiple sheets.

    File is attached for reference.

    Please help

    Thanks in Advance.
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    04-30-2014
    Location
    india
    MS-Off Ver
    Excel 2010
    Posts
    18

    Re: Urgent Help on Summary consolidation from different sheets for particular date

    pls help in solving it

  3. #3
    Forum Expert
    Join Date
    03-28-2014
    Location
    Hyderabad,India
    MS-Off Ver
    Office 365
    Posts
    1,899

    Re: Urgent Help on Summary consolidation from different sheets for particular date

    Hi,

    1) What could be your input details
    2) What is the criteria weather it should be Axis, SBI or all them

    Punnam

  4. #4
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Urgent Help on Summary consolidation from different sheets for particular date

    1) From Forum rules:

    ...If your question has not been answered within a day, consider adding another post with any additional information you believe is relevant. If you think your post is good as is, just reply to your own thread with the words "Bump no response", which will bring it to the top of the forum.
    2) You'll need VBA for this. Do you want to moove your thread at this section?
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

  5. #5
    Registered User
    Join Date
    04-30-2014
    Location
    india
    MS-Off Ver
    Excel 2010
    Posts
    18

    Re: Urgent Help on Summary consolidation from different sheets for particular date

    all Punnam
    I need from all sheets

  6. #6
    Forum Expert
    Join Date
    03-28-2014
    Location
    Hyderabad,India
    MS-Off Ver
    Office 365
    Posts
    1,899

    Re: Urgent Help on Summary consolidation from different sheets for particular date

    Hi Caashishddm

    Please follow instruction of Fotis1991 ,move u r thread to Macros.

    Punnam

  7. #7
    Registered User
    Join Date
    04-30-2014
    Location
    india
    MS-Off Ver
    Excel 2010
    Posts
    18

    Re: Urgent Help on Summary consolidation from different sheets for particular date

    I don't want to use VBA

  8. #8
    Registered User
    Join Date
    04-30-2014
    Location
    india
    MS-Off Ver
    Excel 2010
    Posts
    18

    Re: Urgent Help on Summary consolidation from different sheets for particular date

    is it not possible to solve without vba??/

  9. #9
    Forum Expert
    Join Date
    03-28-2014
    Location
    Hyderabad,India
    MS-Off Ver
    Office 365
    Posts
    1,899

    Re: Urgent Help on Summary consolidation from different sheets for particular date

    Hi Caashishddm

    let me try

    Punnam

  10. #10
    Forum Expert
    Join Date
    03-28-2014
    Location
    Hyderabad,India
    MS-Off Ver
    Office 365
    Posts
    1,899

    Re: Urgent Help on Summary consolidation from different sheets for particular date

    HI ,

    Have look to the sheet which i have uploaded for some clarification.

    Punnam
    Attached Files Attached Files

  11. #11
    Registered User
    Join Date
    04-30-2014
    Location
    india
    MS-Off Ver
    Excel 2010
    Posts
    18

    Re: Urgent Help on Summary consolidation from different sheets for particular date

    thanks and I wish u will get success

  12. #12
    Registered User
    Join Date
    04-30-2014
    Location
    india
    MS-Off Ver
    Excel 2010
    Posts
    18

    Re: Urgent Help on Summary consolidation from different sheets for particular date

    I need in one table and it will mention from which account that transaction is happened

  13. #13
    Registered User
    Join Date
    04-30-2014
    Location
    india
    MS-Off Ver
    Excel 2010
    Posts
    18

    Re: Urgent Help on Summary consolidation from different sheets for particular date

    Any solution developed?

  14. #14
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Urgent Help on Summary consolidation from different sheets for particular date

    @caashishddm

    You didn't reply if the solution of Punnam in #10 worked for you.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  15. #15
    Registered User
    Join Date
    04-30-2014
    Location
    india
    MS-Off Ver
    Excel 2010
    Posts
    18

    Re: Urgent Help on Summary consolidation from different sheets for particular date

    Dear,

    Still my problem is UNSOLVED

  16. #16
    Registered User
    Join Date
    04-30-2014
    Location
    india
    MS-Off Ver
    Excel 2010
    Posts
    18

    Re: Urgent Help on Summary consolidation from different sheets for particular date

    Dear Experts,

    Pls help
    I m still waiting

+ 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: 1
    Last Post: 11-11-2013, 10:28 PM
  2. Due date summary page for multiple sheets
    By missd in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-30-2013, 08:48 AM
  3. [SOLVED] Consolidation of info. Files differing locations, password protected, create one summary
    By marsham in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 04-17-2013, 07:38 PM
  4. Summary of 2 sheets based on Date and Ind ID#
    By koklok in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-12-2009, 06:43 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1