Hi,

Was hoping for a solution to this problem. I have two spreadsheets one that arranges salespeople by role and there associated statistics and the other that arranges them by store. I basically want the statistics from the role based spreadsheet to populate into the stor based spreadsheet based on the salesman name.

Thanks in anticipation.