Hi. I have tried look at this and cant really find out the best way to do it.
I have a part of a sheet with many formulas, and i cant really change that to example insert extra column, it will give a huge work.
In Sheet2 fram range B6 to B370 i would need to be able to put separate text which refer to cell B6. I can t mix the text which is there now .
My idea was maybe there can be a way to double click on cell B6 and then open a text box which i can write in and copy from.
If like that it have to be a specific text box for each cell.
Or other way could be to double click cell B6 and example open a help column and cell AM6 and here write the text. And maybe have text boxes in this help column.
So it was like double click B6 go to AM6, B7 go to AM7, B8 go to AM8, All the way down to B370 and AM370
I am not sure which and how it can be done, maybe other ways are better, The only thing is i cant insert a column.
Please have a look i have attached a test sheet you can try and play with .
Thanks in advance
Sincerely
Abjac
Bookmarks