Hi,
I have a question regarding cells - I have 2 columns with 10 rows and want the 2nd column numbers to be linked (moving) with the numbers in the 1st column.
For example, if A2 changes to A5 (based off filter sorting) B2 will also automatically change with it and move to B5.
Is this possible to do? Or a potential work-around?
Thanks in advance!
I have a question regarding cells - I have 2 columns with 10 rows and want the 2nd column numbers to be linked (moving) with the numbers in the 1st column.
For example, if A2 changes to A5 (based off filter sorting) B2 will also automatically change with it and move to B5.
Is this possible to do? Or a potential work-around?
Thanks in advance!