i need hellp

[ahmedshwoaia]

please i need help
i have table and i want take some information from table 1 to table 2

please see attach

[HansV]

Can you explain what the criteria are for copying information from table1 to table2? Thanks in advance.

[ahmedshwoaia]

if ((c2:c14)) match with (($N$2)) and ((n3:n10)) match with ((k2:k14)), move all information to another table

like attach

[sdckapr]

If I understand what you are trying to do:
In O3:
=IF(SUMPRODUCT((sec=$N$1)*($K$2:$K$14=$N3)*ROW($D$2:$D$14))=0,"",INDEX($D$2:$D$14,SUMPRODUCT((sec=$N$1)*($K$2:$K$14=$N3)*ROW($D$2:$D$14))))

In P3:
=IF($O3="","",SUMPRODUCT((sec=$N$1)*($K$2:$K$14=$N3)*E$2:E$14))

Copy P3 to Q3:T3
Copy O3:T3 to O4:T12

Steve

[ahmedshwoaia]

dear Steve,

please you can apply in attach file.

[ahmedshwoaia]

i have problem in ((o3:o14)) not match with orginal formation

[HansV]

Here is your workbook with Steve's formulas, and with the dropdown in N1 moved to N2 as in your second sample workbook.

[sdckapr]

You can do this by yourself:
Put the formulas I listed in the your original file, then insert the new row and the formulas will adjust automatically...

Or put my formulas in the new workbook and then edit them to increase each of the row numbers by 1 to manually adjust them.

Steve

[ahmedshwoaia]

thanks Steve and hansv