Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Mar 2006
    Location
    Philadelphia, PA
    Posts
    30
    Thanks
    12
    Thanked 0 Times in 0 Posts

    Link Several sources to one spreadsheet.

    Hello! I'm kerplumt!

    Please see attached file. It has 2 spreadsheets. the first spreadsheet is a common worksheet that has been copied for 8 unique accounts. The 2nd spreadsheet has the unique accounts with revenue codes and totals for the month.

    Instead of filtering on the accounts, then copying and pasting the data into each spreadsheet, I'd like to create a formula that will id the 1st 3 digits of the unique accounts and pull the relevant revenue codes and monthly values from the common sheet.

    Will a index match work? Or should I look into naming a range?
    Attached Files Attached Files

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    I am not exactly sure what numbers you want calculated and where they come from in your example.

    Just a guess here but are you looking for something in Solucient!G2 (expand the range as desired):
    =SUMIF('Radiation ONcology (2)'!$P$18:$P$167,A2,'Radiation ONcology (2)'!$R$18:$R$167)

    This can be copied down the column

    Steve

  3. The Following User Says Thank You to sdckapr For This Useful Post:

    ab2537 (2012-08-12)

  4. #3
    Lounger
    Join Date
    Mar 2006
    Location
    Philadelphia, PA
    Posts
    30
    Thanks
    12
    Thanked 0 Times in 0 Posts
    I think this is a part of my solution. will work with this to see if I can figure out the rest! Thanks!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •