Excel generating table from data

Hello,

Need help with excel generating automatically data

I have full list of data in columns A to F.

In J4 i want to select supllier from pick list (firstly defined) and after that in J7 -
M7 should be placed info from A to F (J7 is C2, K7 is D2, L7 is E2, M7 is F2).

In table, there should be as many rows, as how much rows with this supllier is in data columns (A to F). Next row after final automatically made row should sum all rows togeter (m7, m8 in example).

Is it possible?

Added excel also.

Thanks,
Siim

OR,

Try the following array formula in J7:

Please Login or Register  to view this content.

to be confirmed by pressing CTRL+SHIFT+ENTER

drag this down the cells and across until column L.

In M7:

Please Login or Register  to view this content.

array entered as well, to be confirmed by pressing CTRL+SHIFT+ENTER

See the attached file.