Referring Different Excel Sheets in Excel Table

[4dv3nt]

Hello
I'm trying to do simple inventory management forms in excel but i got stuck at referring component names in excel table

I'm trying to do "" ='S1'!C2 "" in a cell and then i press enter and add for the second sheet "" ='S2'!C2 "" and it will go on till "" ='S200'!C2 ""

but

when i write first one and then add second one it changes whole column like "' =S2'!C1 "" + "=S2'!C2 "" + "" =S2'!C3 ""

or

if i try to continue then whole column become "' =S3'!C1 "" + "' =S3'!C2 "" + "' =S3'!C3 ""

hope you can understand my problem and sorry for my bad english.

Thanks for help

[canapone]

Hi,

you could try

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

Cheers