software

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: www.excelforum.com/member.php...oamp;userid=32596
View this thread: www.excelforum.com/showthread...hreadid=525106
To place a space between each entry use this: -

=Sheet1!A1amp;quot; quot;amp;Sheet1!B1amp;quot; quot;amp;Sheet1!C1

To not place a space between use: -

=Sheet1!A1amp;Sheet1!B1amp;Sheet1!C1

Place the formula into sheet 2 and it will display the entry in Sheet 1
(Cells 1,2 amp; 3)--
y_not
------------------------------------------------------------------------
y_not's Profile: www.excelforum.com/member.php...oamp;userid=19947
View this thread: www.excelforum.com/showthread...hreadid=525106