This is what I'm trying to acheive;
When someone double clicks on a cell in row 4 (columns J to AM), the worksheet unlocks, copies the contents of the column to the left, pastes it into that column and re-locks the worksheet.
eg - double click on J4, (unlocks) copies contents of column I, pastes it into column J (re-locks)
Is this possible?
Thanks in advance!
When someone double clicks on a cell in row 4 (columns J to AM), the worksheet unlocks, copies the contents of the column to the left, pastes it into that column and re-locks the worksheet.
eg - double click on J4, (unlocks) copies contents of column I, pastes it into column J (re-locks)
Is this possible?
Thanks in advance!