Forum Discussion
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
Javaid786 Use absolute column reference. Dollar sign $ will lock row/column while dragging right and down. So, use-
=$A1+10To above formula when you drag to right Column A will remain absolute.
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