SOLVED

# Getting Left cell data while dragging towards right side

Copper 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

2 Replies

# Re: Getting Left cell data while dragging towards right side

@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

# Re: Getting Left cell data while dragging towards right side

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

1 best response

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

# Re: Getting Left cell data while dragging towards right side

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