Hello guys I hope there is a non vba solution for this problem:
Suppose I have a workbook with cells containing text. Can I Display each cell content in 1 other cell after selecting the cell I want to display? so each cell will be displayed in that particular cell whenever it is selected.
for example
cells A1:A5 has the following text values:
Dermot
Johnson
Reece
Douglas
Ionie
If cell B1 is the target cell:
when I select A1 I should see "Dermot" Displayed in B1
when I select A2 I should see "Johnson" Displayed in B1
when I select A3 I should see "Reece" Displayed in B1
and so on
I hope someone can help thanks.
Suppose I have a workbook with cells containing text. Can I Display each cell content in 1 other cell after selecting the cell I want to display? so each cell will be displayed in that particular cell whenever it is selected.
for example
cells A1:A5 has the following text values:
Dermot
Johnson
Reece
Douglas
Ionie
If cell B1 is the target cell:
when I select A1 I should see "Dermot" Displayed in B1
when I select A2 I should see "Johnson" Displayed in B1
when I select A3 I should see "Reece" Displayed in B1
and so on
I hope someone can help thanks.