How to Find selected Active cell highlighted with Color and copy the data provided in the cell above to some special assigned cell
<p>I am new to VBA so if somebody help me to solve my problem then I shall be really grateful as I am stuck with it.
<a href="https://i.stack.imgur.com/pFWBq.jpg" rel="nofollow noreferrer">enter image description here</a>
Please have a look at the attached picture below and if somebody provide me code for VBA then it will be really helpful for me. Task contains following steps.</p>

<p>1-  In row 11 dates are provided in corresponding columns. Like 16/11, 17/11, 18/11 etc.</p>

<p>2-  From row (12 to 29) I have different tasks to do are provided.</p>

<p>My task is.</p>

<p>1-  When I select any cell/ box by filling it with any color the date available in the (row 10) above that cell (automatically goes/copies) to the specified cell mentioned for that task.
For Example: I select Row 21 AQR presentation cell and highlight it by filling it with color so the date above that cell automatically goes/copies to specified cell mentioned above for AQR presentation and similarly I have to do with every cell.</p>

<p>Request:</p>

<p>I need a code that detects the active cell which is highlighted and sends the date above that cell to a specified folder mentioned for that above. </p>

<p>Please see the figure for more clear understanding.</p>

<p>I shall be grateful if somebody help me in providing the code for this. </p>