would like code for each cell in order to pull necessary data from the tables on the right and make the necessary calculations to achieve the results show as follows:

The sales person shown in B7 means that data for this area will be taken from the table labeled "weaver" to the right. The data corresponds as follows:

B6 is simply the DATA found in Z14

C5 is the sum of all data from X4:X13 found in column "W" hence the result 5

D5 is them sum of all data from Y4:Y13 column "L"

E5 is the minimum number found in Z4:Z13 column 'ERA'

F5 is the maximum number found in AD4:AD13 COLUMN 'ER'

G5 is the average of all number found in AD4:AD13 column 'ER'

H5 is the minimum number found in AF4:AF13 column 'SO'

I5 is the maximum number found in AF4:AF13 COLUMN 'SO'

C7 is the sum of all data from X9:X13 found in column "W" hence the result 5

D7 is them sum of all data from Y9:Y13 column "L"

E7 is the average of data found in Z9:Z13 column 'ERA'

F7 is the minimum number found in AD9:AD13 COLUMN 'ER'

G7 is the maximum l number found in AD9:AD13 column 'ER'

H7 is the minimum number found in AF9:AF13 column 'SO'

I7 is the maximum number found in AF9:AF13 COLUMN 'SO'

The same will be done for the side of "Salazar" only this time the data will taken from table with his name (i.e. Salazar). and put into the correspoding cells within the table.

DataCalculations.xlsx
literalExcel functions which satisfy your requirements. There's nothing particularly difficult here, just MIN, MAX, and AVERAGE functions.That said, your "sales person" data arrangement here is not open-ended and new formulas would have to be manually reconstructed if there are changes to the data tables in either size or position. And if new "sales person" reporting is required, that would also mean new manual creation of formulas.

If this is merely an academic exercise, then this should suffice. But if there is an actual work need that requires expandability, you'll need to provide a more concrete example.

Regards,

-Glenn

EE-DataCalculations.xlsx