At present, I am trying to fill a column with the data from a row on another sheet. The data in that sheet, does change and being inherintley lazy, I ponly want to change one set of data (the row also reflects on another sheet as a row)
When I place the value into the 1st cell it reads '='IDs and Naming'!B3' but if i try to do a drag fill it wil read '='IDs and Naming'!B4' and '='IDs and Naming'!B5' and so on. What I am wanting to do is have the column increment up and not the cell number.
Is there a way to achieve what I am after?
When I place the value into the 1st cell it reads '='IDs and Naming'!B3' but if i try to do a drag fill it wil read '='IDs and Naming'!B4' and '='IDs and Naming'!B5' and so on. What I am wanting to do is have the column increment up and not the cell number.
Is there a way to achieve what I am after?