+ Reply to Thread
Results 1 to 3 of 3

Match and Transfer data

  1. #1
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,379

    Match and Transfer data

    Hi:

    Please open the attached excel file for referance.
    Go to Sheet1

    I have Sheets named 505,512,519,526,602.

    In this sheets
    Column A : Account ID
    Column C : # Of Record
    Column D : # of Full Billable
    etc

    Based on the Catagory you select from drop down list in cell A1, i need the sheet data transfered
    to Sheet1.


    I tried using SUMPRODUCT, SUMIF function but failed.

    =SUM(IF('505'!$A$2:'505'!$A$350=A6,IF('505'!$C$1=$A$2,'505'!$C$2:'505'!$C$350,0),0))

    Please help me with this.

    Thanks a lot

    Riz
    Attached Files Attached Files
    Last edited by rizmomin; 07-23-2012 at 05:46 AM.

  2. #2
    Forum Expert
    Join Date
    01-15-2007
    Location
    Brisbane, Australia
    MS-Off Ver
    2007
    Posts
    6,591

    Re: Match and Transfer data

    Hi

    Try this on Sheet1

    B1: =MATCH(A1,'505'!1:1,0)
    B6: =OFFSET(INDIRECT($B$5&"!$a$1"),MATCH($A6,INDIRECT($B$5&"!A:A"),0)-1,$B$1-1)

    Copy down / across as required.

    Note that the items in A1 will have to EXACTLY match the headings on sheet 505, and that all the sheets will have to be in the same order.

    HTH

    rylo

  3. #3
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,379

    Re: Match and Transfer data

    Hi Rylo:

    Thank you so much ...this works perfect.

    Riz

+ 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