Hi,
I have a multiple sheets in the excel workbook. I need to grab cells Q13 and Q15 from each sheets. I need to a create a vba code for the following positive criteria conditions should be met if:
- Q13 is Yes, Q15 is No;
- Q13 is No, and Q15 is Yes;
- and both Q13 and Q15 are Yes
The output should be displayed in "DestinationSheet" as (Conditions Met or not met) under column D by offset 1 row
**Also in each worksheets, the integers 1 and 2 have already been references as "Yes" and "No" respectively.
I'd kindly appreciate it if you help on it.
I have a multiple sheets in the excel workbook. I need to grab cells Q13 and Q15 from each sheets. I need to a create a vba code for the following positive criteria conditions should be met if:
- Q13 is Yes, Q15 is No;
- Q13 is No, and Q15 is Yes;
- and both Q13 and Q15 are Yes
The output should be displayed in "DestinationSheet" as (Conditions Met or not met) under column D by offset 1 row
**Also in each worksheets, the integers 1 and 2 have already been references as "Yes" and "No" respectively.
I'd kindly appreciate it if you help on it.