I have two sheets on the first sheet, Column A have the project name, I have Columns K, L, U where I have dates that change on a weekly basis. On Sheet two I have same thing starting with A27, I have the same project names, however on F27, G27 and H27 where I manually enter the historical changes of dates manually stacked.
What I am trying to do is on sheet two, if K, L, U dates change at any time on sheet one, record them on sheet two, for the right project(names to match ) and have those stacked where the newest value is on top in the cell and past ones are pushed to bottom.
i.e. where on sheet 1 on U column, once date 3 changed to 3/3/2018 for project A , it should add it on sheet 2, column H, for project A, for the Date 3.
Sheet1
A K L U
<colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>
</tbody>
Sheet 2
A E F H
<colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>
</tbody>
Also wondering whether a way to utilize concatenate here without vba?
Thank you so much for all help!
What I am trying to do is on sheet two, if K, L, U dates change at any time on sheet one, record them on sheet two, for the right project(names to match ) and have those stacked where the newest value is on top in the cell and past ones are pushed to bottom.
i.e. where on sheet 1 on U column, once date 3 changed to 3/3/2018 for project A , it should add it on sheet 2, column H, for project A, for the Date 3.
Sheet1
A K L U
Project | Date1 | Date 2 | Date 3 |
Project A | 1/1/2018 | 1/1/2018 | 3/3/2018 |
Project B | 2/2/2018 | 2/2/2018 | 2/2/2018 |
<colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>
</tbody>
Sheet 2
A E F H
Project | Date1 | Date 2 | Date 3 |
Project A | 1/1/2018 5/5/2017 | 1/1/2018 6/6/2017 | 3/3/2018 1/1/2018 7/7/2017 |
Project B | 2/2/2018 3/3/2017 | 2/2/2018 4/4/2017 | 2/2/2018 5/5/2017 |
<colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>
</tbody>
Also wondering whether a way to utilize concatenate here without vba?
Thank you so much for all help!