SOLVED

Getting Left cell data while dragging towards right side

Copper Contributor

 i will share with you for better understanding what i am looking for 

Javaid786_0-1718085088164.png

 

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

 

2 Replies

@Javaid786 Use absolute column reference. Dollar sign $ will lock row/column while dragging right and down. So, use-

=$A1+10

To above formula when you drag to right Column A will remain absolute. 

best response confirmed by Javaid786 (Copper Contributor)
Solution

@Harun24HR 

 

its not like that i will share with you for better understanding what i am looking for 

Javaid786_0-1718018693876.png

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

1 best response

Accepted Solutions
best response confirmed by Javaid786 (Copper Contributor)
Solution

@Harun24HR 

 

its not like that i will share with you for better understanding what i am looking for 

Javaid786_0-1718018693876.png

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

View solution in original post