Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 7 of 7

Thread: Linking Multiple Cells to Single Cell

  1. #1
    Join Date
    30th June 2006
    Posts
    146

    Linking Multiple Cells to Single Cell

    I have a list in column A, with individual text information in each cell.
    I would like to set it up such that when I select a cell (eg. A1) from the column list, it's contents is referenced to another cell. (eg B1)

    And when i click on another cell from the column list (eg. A2), the contents of this cell replaces the first selection with it's contents, in the same cell (B1.)

    I'm aware of the simple "=" insert, but it relates to two cells only...


    Can this be accomplished?


    Thanks for any help

    ~Jeff
    Last edited by Jeff P; July 18th, 2006 at 12:29.

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    24th January 2003
    Location
    Australia
    Posts
    31,713

    Re: Linking Multiple Cells to Single Cell

    Are you saying that any cell you select in Column "A" is copied to cell B1?

  3. #3
    Join Date
    30th June 2006
    Posts
    146

    Re: Linking Multiple Cells to Single Cell

    Thanks for the speedy reply, Dave!

    As for your question.. Yes, In fact every cell containing text from column A would be copied (or temporarily displayed) to B1.


    I'm thinking more along the lines of a switch,.. (multiple inputs to one output.) eg. ten computers connected to one monitor, yet only one can be visible. ..

    So with each cell selected within column A, only that particular cells contents would be displayed in B1.. until a new cell from column A was selected. (in which it's contents only, would then be displayed in B1, etc..)




    thanks again!

    Jeff
    Last edited by Jeff P; July 18th, 2006 at 13:18.

    Excel Video Tutorials / Excel Dashboards Reports


  4. #4
    Join Date
    24th January 2003
    Location
    Australia
    Posts
    31,713

    Re: Linking Multiple Cells to Single Cell

    Right click on the sheet name tab, choose View Code and in here paste the code below
    VB:
    Private Sub Worksheet_SelectionChange(ByVal Target As Range) 
        If Target.Column = 1 Then Range("B1") = Target 
    End Sub 
    
    

  5. #5
    Join Date
    30th June 2006
    Posts
    146

    Re: Linking Multiple Cells to Single Cell

    Wow, thanks for the detailed solution... it worked like a charm!

    yet.... I wish I knew why...

    I'm trying to understand what exactly is going on... Not sure how it knows to use column A as the source

    My initial inquiry was a mere example, to keep it simple... I was hoping to simply exchange your code with the relevant to my specific situation...
    but now, i'm completely lost.

    ....In actuality my true inquiry was to be used as such: from worksheet1 Column E to be referenced in worksheet2 B1


    any chance of getting an update? (...sorry about that)


    if not ... no worries, I've seen that it can work, and will do some research and figure out what's going on.


    Thanks again for the help!

    Jeff
    Last edited by Jeff P; July 18th, 2006 at 15:06.

    Excel Video Tutorials / Excel Dashboards Reports


  6. #6
    Join Date
    24th January 2003
    Location
    Australia
    Posts
    31,713

    Re: Linking Multiple Cells to Single Cell

    Add the code below to Worksheet 1
    VB:
    Private Sub Worksheet_SelectionChange(ByVal Target As Range) 
        If Target.Column = 5 Then Worksheets(2).Range("B1") = Target 
    End Sub 
    
    

  7. #7
    Join Date
    30th June 2006
    Posts
    146

    Re: Linking Multiple Cells to a Single Cell

    Now I understand what's going on.... tremendously helpful.


    ... thanks for all the help, Dave!


    ~Jeff

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. Replies: 8
    Last Post: September 24th, 2010, 11:06
  2. Split Single Cell Object Into Multiple Cells
    By gurunath_s_r in forum EXCEL HELP
    Replies: 2
    Last Post: August 13th, 2008, 11:00
  3. Join Multiple Cells Into Single Cell
    By vinothkumar2it in forum EXCEL HELP
    Replies: 2
    Last Post: June 19th, 2008, 19:03
  4. Check Multiple Cells For Value Of Single Cell
    By juju918 in forum EXCEL HELP
    Replies: 4
    Last Post: April 29th, 2008, 10:43
  5. Single Cell To Multiple Cells Using Line Breaks
    By joenjoe in forum EXCEL HELP
    Replies: 1
    Last Post: December 25th, 2007, 21:12

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
porno