linking multiple cells to 1 cell

G'day and welcome to the forum,

Try this

=Sheet2!A1&Sheet!B1

If a space is needed

=Sheet2!A1&" "&Sheet!B1

Hope this helps

Originally Posted by ratcat

G'day and welcome to the forum,

Try this

=Sheet2!A1&Sheet!B1

If a space is needed

=Sheet2!A1&" "&Sheet!B1

Hope this helps

hey thanx for the reply but i want the data to change in sheet1 as i enter data to a single cell in sheet2 not stay there in sheet1

Please upload a small example and will go from there.

I'm unclear of what your results your after.

Thanks

G'day sohilbhai,

Thanks for the attachment.

After viewing the attachment, it seems that the cell you want from 'Sheet 2' will move according to other entries, like different month of the year and the Put Sell and the Call Sell.

I've used the Index and Match formula.

All you need to do is enter your raw data into 'Sheet 2' then on 'Sheet 1' change cells E1, C2, C3, and C5 to the information your looking for, then the information on 'Sheet 2' will appear in cells E2, E3, and E5.

Hope this helps

Please post if more help is needed