+ Reply to Thread
Results 1 to 2 of 2

link multiple cells to multiple cells

  1. #1
    Registered User
    Join Date
    03-18-2006
    Posts
    10

    link multiple cells to multiple cells

    I would like to link multiple cells to multiple cells in different worksheets

    sheet 1 -I have inputs from three different columns and would like them to go into one master column in sheet 2

    I dont want any spaces so I dont know how to link the two sheets

    Also everytime i input something in one of the three columns of sheet 1 I would like them to transfer to the master column in sheet 2, so copy and paste isnt an option

    Please help

    I really appreciate all that everyone does to help

    Thanks

  2. #2
    Forum Contributor
    Join Date
    02-15-2005
    Location
    Central UK
    MS-Off Ver
    Office 365
    Posts
    175
    To place a space between each entry use this: -

    =Sheet1!A1&" "&Sheet1!B1&" "&Sheet1!C1

    To not place a space between use: -

    =Sheet1!A1&Sheet1!B1&Sheet1!C1

    Place the formula into sheet 2 and it will display the entry in Sheet 1 (Cells 1,2 & 3)

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1