• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Display cell content in another cell by selecting the cell.

Dermot

New Member
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.
 
Dermot

Firstly, Welcome to the Chandoo.org Forums

You can't do what you want without some VBA
Now that I have said that, somebody will show us how
 
Here comes somebody…
2 sheets, code in each sheet's code-module.
 

Attachments

  • Chandoo41914.xlsm
    18.7 KB · Views: 3
Thank you Hui and p45ca,l this solved the problem.
However I wanted the file to also be smartphone usable, is this possible?
 
Back
Top