Hi all, Have a simple Table1 where in column C are Dates, in column D Status, and Column E Update.
What I wish for is that when a cell in Column E changes its value (it's data validation list) to do this:
Add value of cell to cell in column C (simple C.value=C.value+E.value*7)
Check if E.value was positive, if so
Find first "Priority" in D Status column, assign previous date value of changed cell
and at the end for any case
Set value of cell in E as blank
ex.
Initial
....A........B.......C.........D......E
<tbody>
</tbody> Let say we change E2 to -2
....A........B.......C.........D......E
<tbody>
</tbody> Date has updated by -2*7 days, now what if it was initially 2 in E2
....A........B.......C.........D....E
<tbody>
</tbody> Test4 took a place of Test2
The rest got auto sorted by date
I thought it's gonna be easy, started to make a code, but just keep on getting error after error and crashes.
Any help?
Thanks
What I wish for is that when a cell in Column E changes its value (it's data validation list) to do this:
Add value of cell to cell in column C (simple C.value=C.value+E.value*7)
Check if E.value was positive, if so
Find first "Priority" in D Status column, assign previous date value of changed cell
and at the end for any case
Set value of cell in E as blank
ex.
Initial
....A........B.......C.........D......E
Test1 | Test1 | 28.1 | ||
Test2 | Test2 | 28.2 | E2 | |
Test3 | Test3 | 28.3 | ||
Test4 | Test4 | 28.4 | Priority | |
Test5 | Test5 | 28.5 |
<tbody>
</tbody>
....A........B.......C.........D......E
Test1 | Test1 | 28.1 | ||
Test2 | Test2 | 14.2 | ||
Test3 | Test3 | 28.3 | ||
Test4 | Test4 | 28.4 | Priority | |
Test5 | Test5 | 28.5 |
<tbody>
</tbody>
....A........B.......C.........D....E
Test1 | Test1 | 28.1 | ||
Test4 | Test4 | 28.2 | Priority | |
Test2 | Test2 | 14.3 | ||
Test3 | Test3 | 28.3 | ||
Test5 | Test5 | 28.5 |
<tbody>
</tbody>
The rest got auto sorted by date
I thought it's gonna be easy, started to make a code, but just keep on getting error after error and crashes.
Any help?
Thanks
Last edited: