+ Reply to Thread
Results 1 to 4 of 4

Copy values from identical sheets in a workbook to summary sheet

  1. 10-17-2011, 06:24 PM #1
    kammariarun is offline
    Registered User
    Join Date
    10-05-2011
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    57

    Copy values from identical sheets in a workbook to summary sheet

    Hello,

    I need to populate data from different identical sheets to a summary sheet. All sheets have identical columns headings and rows headings except the cell value. I want to know if there is any simple way to copy than physically selecting each sheet. I have appended the sheet. Any help is greately appreciated
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 10-18-2011, 12:39 AM #2
    Azam Ali is offline
    Valued Forum Contributor
    Join Date
    05-23-2011
    Location
    Lahore PK
    MS-Off Ver
    Excel 2007, 2013
    Posts
    627

    Re: Copy values from identical sheets in a workbook to summary sheet

    See attatchment
    Attached Files Attached Files
    Last edited by Azam Ali; 10-18-2011 at 12:41 AM.
    Azam
    If you want to say Thank you to a member, click the reputation icon (Star) in the left bottom of the post.
    For prompt answer, be descriptive, concise, short, direct, and to-the-point.
    Reply With QuoteRegister To Reply
  3. 10-18-2011, 03:50 PM #3
    kammariarun is offline
    Registered User
    Join Date
    10-05-2011
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    57

    Re: Copy values from identical sheets in a workbook to summary sheet

    Quote Originally Posted by Azam Ali View Post
    See attatchment
    Hi Azam,

    Thank you very much. It is exactly does what I needed but I have no clue what it is doing. Can you please explain the formula.

    Thanks
    Reply With QuoteRegister To Reply
  4. 10-19-2011, 04:25 AM #4
    Azam Ali is offline
    Valued Forum Contributor
    Join Date
    05-23-2011
    Location
    Lahore PK
    MS-Off Ver
    Excel 2007, 2013
    Posts
    627

    Re: Copy values from identical sheets in a workbook to summary sheet

    Use evaluate formula option in the formula tab in order to understand the formula
    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)

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