S
solo
Hopefully a simple question
I am knocking-up a spreadsheet which requires the use of spinners and
check boxes.
The problem I have is that after I set the format control of each of
these objects to the box they are sitting on they stay at this value if
I copy or move them. I thought I had cracked this when I realised they
were absolute values however when I took out the $s it had no effect
whatsoever.
Basically I am looking for a way to reference these cells so that they
are not absolutely referenced and can be moved/copied without having to
be individually amended.
Hope that makes sense and TIA
I am knocking-up a spreadsheet which requires the use of spinners and
check boxes.
The problem I have is that after I set the format control of each of
these objects to the box they are sitting on they stay at this value if
I copy or move them. I thought I had cracked this when I realised they
were absolute values however when I took out the $s it had no effect
whatsoever.
Basically I am looking for a way to reference these cells so that they
are not absolutely referenced and can be moved/copied without having to
be individually amended.
Hope that makes sense and TIA