Dear Friends,
KINDLY HELP with the attached .xlsx file as per the given conditions. I would like to thank in advance. I know you will be able to help me write a VBA Code for the same.
There is an INPUT DATA (A2:F6) and an OUTPUT DATA (A11:M14).
The output data has been manually filled following the given conditions :-
1. To Copy :- Copy cells between B3 and F6. If B3 = 0, then skip to next row starting from B4.
2. To Paste in the output data, Paste such that :-
a) Condition for ROW :- If the contents of A11 belong to A2:A6, then only fill row 11. For example, A11 (A) is a part of A3 (A,B,C), A4 (A,B), A5 (A,C). So, only copy the contents of Row 3,4 and 5 and paste in row 11. Note that A11 (A) is not a part of A6 (B,C), so row 6 hasn't been copied.
b) Condition for COLUMN :- If in the output data, sum = 0, only then start pasting the data of the next row of input data. eg. if sum in B14 = 0, only then paste data of B3. if sum in C14 = 0, only then paste data of C3.
c) If the location of Output data does not belong to the location of input data, then do not copy paste the corresponding data. eg. Since 46 and 41 belong to all A,B and C, 46 and 41 have been copied to row 11, 12 and 13 (i.e. all locations A, B and C). Another example, since 11,11,11,11 and 5 belong to A and B only, it has been copied to row 11 and 12 (i.e locations of A and B only). Meanwhile row 13 i.e. Location C has been kept empty.
For convenience, color coding of data has been done.
Reply With Quote