Hi,
I have a multiple sheets in the excel workbook. I need to grab cells Q13 and Q15 from each sheets then 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 Met or not met under column D by offset 1 row
I'd really appreciate it if you could help me on this
I have a multiple sheets in the excel workbook. I need to grab cells Q13 and Q15 from each sheets then 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 Met or not met under column D by offset 1 row
I'd really appreciate it if you could help me on this