Forum Discussion

Javaid786's avatar
Javaid786
Copper Contributor
Jun 10, 2024

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

 

  • Harun24HR 

     

    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

  • Harun24HR's avatar
    Harun24HR
    Bronze Contributor

    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. 

    • Javaid786's avatar
      Javaid786
      Copper Contributor

      Harun24HR 

       

      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

Resources