link multiple cells to multiple cells

J

jpoltor

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

sheet 1 -I have inputs from three different columns and would like the
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
I would like them to transfer to the master column in sheet 2, so cop
and paste isnt an option

Please help

I really appreciate all that everyone does to help

Thank
 
Y

y_not

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)
 
Top