Hi All,
I have to perform a task af mainting a list of articles and som data releated to it.
what i need is an output that looks like this
<tbody>
</tbody>
I have to loop thorugh 2 different WB to be able to do this
in A2 and B2 i have to go through all sheets in WB1 and if there is a value in column "C" it should copy the values in "C" and "D" and insert them into the acwb.
in C2 i need it to loop through WB2 in and sum all values in column "AC" and divide it with "Y" (sumif(D:D,A2,AC:AC)/sumif(D:D,A2,Y:Y))
in D2 and nth2 i need it to find every occurence of A2 in WB2 and do: = "sheetname"&" "&(AC/Y)
i know this is is very specific, but i hope someone could help me with this task
best regards
Hawjeen
I have to perform a task af mainting a list of articles and som data releated to it.
what i need is an output that looks like this
Article number | article text | avg. factor | 1st occ | 2nd occ | 3th occ | 4th occ | 5th occ | 6th | 7th | 8th | 9th | 10th |
<tbody>
</tbody>
I have to loop thorugh 2 different WB to be able to do this
in A2 and B2 i have to go through all sheets in WB1 and if there is a value in column "C" it should copy the values in "C" and "D" and insert them into the acwb.
in C2 i need it to loop through WB2 in and sum all values in column "AC" and divide it with "Y" (sumif(D:D,A2,AC:AC)/sumif(D:D,A2,Y:Y))
in D2 and nth2 i need it to find every occurence of A2 in WB2 and do: = "sheetname"&" "&(AC/Y)
i know this is is very specific, but i hope someone could help me with this task
best regards
Hawjeen