link formula to sheet.

[Tom]

Hi all

I need a formula that will link to the same cell in
different worksheets. for example a1 will be c2 in
worksheet 1. b2 will be c2 in worksheet 2 etc.......

thanks for you help in advance.

 

[Frank Kabel]

Hi
try
='sheet2'!C2

 

[Tom]

can i find a formula that will do this automatically when
i filter down?

Thanks.

 

[Frank Kabel]

Hi
not really sure what you mean with 'filter down'