Hello! I’m kerplumt!:o:
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?
