The data to be put in different rows of a column is referred from same row of different columns in a separate sheet while the data to be put in the next column is referred from second row different columns from that other sheet.this is the sheet where the data is to be put, different cells of same color is referred from different rows of the second sheet
which is- this is the second sheet and the different cells of same color go into different columns in first sheet
I’ve tried the basic $ but it locks the row as well wen dragged across the columns in sheet 1 (works correctly if dragged across rows as it is may be meant to?
I’ve tried the basic $ but it locks the row as well wen dragged across the columns in sheet 1 (works correctly if dragged across rows as it is may be meant to?
Shreshth is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.