Excel or Google forms - How to identify a specific cell on a table and update value from another worksheet data
<p>I have 2 work sheets. Sheet 2 has a table to be updated by the data from Sheet1. Sheet 2 first row has dates from today to 31 days and First column has names. Sheet1 has data columns of, Name, Shift (Give away, Swap, Delete, Take), Date, Letter( Which gives a letter as per Shift column entry. G - Give away, S- Swap, D- Delete, A - Take). What I need is a formula or a script to update Sheet2 by identifying the particular cell on sheet 2 by name and date from the Sheet 1 and enter the value from Letter column.</p>

<p>Sheet 1</p>

<pre><code>Name | Shift.....| Date....| Letter..|    
Mark | Swap      |  02/AUG | S       |    
Ivon | Give away | 25/ AUG | G       |    
Laura| Take      | 01/AUG  | A       |     
Ann  | Take      | 02/AUG  | A       |    
Ann  | Give away | 03/AUG  | G       |
</code></pre>

<p>Sheet 2</p>

<pre><code>|Name|01/AUG| 02/AUG | 03/AUG|....| 25AUG|

Laura| A    | &lt; - if Laura has is available to Take a shift on 01AUG

Mark |      | 

Ann  |      | A      | G      | &lt;- If Ann has is available to Take a shift on 02AUG and Give away shift on 03AUG

Ivon |
</code></pre>