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


--
jpoltor
------------------------------------------------------------------------
jpoltor's Profile: http://www.excelforum.com/member.php...o&userid=32596
View this thread: http://www.excelforum.com/showthread...hreadid=525106

link multiple cells to multiple cells
 

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)


--
y_not
------------------------------------------------------------------------
y_not's Profile: http://www.excelforum.com/member.php...o&userid=19947
View this thread: http://www.excelforum.com/showthread...hreadid=525106