linking multiple cells to 1 cell

**sohilbhai** · 06-28-2008, 03:03 AM

hi i am using excel 2003 i want to link multiple cells from sheet 2 to 1 cell in sheet1 so that when that data entered in sheet2 cells is changed accordingly in sheet1 cell keeping in mind the data is not deleted in sheet2 cells...please suggest thank you...

**ratcat** · 06-28-2008, 03:32 AM

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

**sohilbhai** · 06-28-2008, 03:45 AM

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

**ratcat** · 06-28-2008, 03:58 AM

Please upload a small example and will go from there.

I'm unclear of what your results your after.

Thanks

**sohilbhai** · 06-29-2008, 01:35 AM

[QUOTE=ratcat]Please upload a small example and will go from there.

I'm unclear of what your results your after.

Thanks
here dwnld the attachment

**ratcat** · 06-29-2008, 07:59 AM

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

**sohilbhai** · 06-30-2008, 12:46 AM

Originally Posted by ratcat

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

hi ratcat thanx for the advice
but would like to knw how did u go about the index & match formula...thnx