Forum Discussion
Javaid786
Jun 10, 2024Copper Contributor
Getting Left cell data while dragging towards right side
i will share with you for better understanding what i am looking for
1st & 2nd row is showing we sold to customer each month by month amount mentioned
Down 2 rows are expected to receive payment as we have credit 7 months means Nov Amount 307,415 (mentioned in row 2)is expected to receive in June 24 & Dec Amount 261,707 in July-24 & so on, if i make june-24 link with nov amount 307,415 & drag to july it will not give me data of dec as dragging will show data next cell not previous cell , actually what i need is while i drag cell towards right cell it should show me data of left cell, i hope it clears what i need exactly.
like this i have 100 customers & its hard to do all of them manually
its not like that i will share with you for better understanding what i am looking for
1st & 2nd row is showing we sold to customer each month by month amount mentioned
Down 2 rows are expected to receive payment as we have credit 7 months means Nov Amount 307,415 (mentioned in row 2)is expected to receive in June 24 & Dec Amount 261,707 in July-24 & so on, if i make june-24 link with nov amount 307,415 & drag to july it will not give me data of dec as dragging will show data next cell not previous cell , actually what i need is while i drag cell towards right cell it should show me data of left cell, i hope it clears what i need exactly.
like this i have 100 customers & its hard to do all of them manually
- Javaid786Copper Contributor
its not like that i will share with you for better understanding what i am looking for
1st & 2nd row is showing we sold to customer each month by month amount mentioned
Down 2 rows are expected to receive payment as we have credit 7 months means Nov Amount 307,415 (mentioned in row 2)is expected to receive in June 24 & Dec Amount 261,707 in July-24 & so on, if i make june-24 link with nov amount 307,415 & drag to july it will not give me data of dec as dragging will show data next cell not previous cell , actually what i need is while i drag cell towards right cell it should show me data of left cell, i hope it clears what i need exactly.
like this i have 100 customers & its hard to do all of them manually