Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Part No | Year | Part Desc. | Supplier Code | Plant Code | Release Date | 28-Mar | 4-Apr | 11-Apr | 18-Apr | 25-Apr | 2-May | 9-May | 16-May | 23-May |
A | 2016 | XYZ | AAA | AAA1 | 3/28/2016 | T | S | |||||||
4/4/2016 | T1 | |||||||||||||
4/11/2016 | ||||||||||||||
4/18/2016 | ||||||||||||||
4/25/2016 | ||||||||||||||
5/2/2016 | ||||||||||||||
5/9/2016 | ||||||||||||||
5/16/2016 | ||||||||||||||
5/23/2016 | S1 |
above is pivot table where in forecast date has been dragged to the top so that each forecast date acts as a column
Suppose all the cells are filled with values.
Part number A has been selected in the application
Now i want to bring value from cell S of release date 28/03/2016 and forecast date 23 may to the cell T of release date 28/03/2016 and forecast date 4 april
Similary i want to bring value from cell S1 to T1.
The logic should work dynamically in case release week is selected from 3/28 to 9/5
In that case
bring value from cell of release date 28/03/2016 and forecast date 9 may to the cell of release date 28/03/2016 and forecast date 4 april
Regards,
Jatin
What is your intention of doing this ?
Once i get the required value in the target cell, i will doing subtraction of that cells value and the new broughtin value and get the difference