Cell reference to an autofilterd worksheet problem

[ketantantod]

Hi,

I have a cell reference problem and I'm hoping someone can please help me. On worksheet 1 I have a list of total members that has autofilters so that I can sort by subgroups. Then on worksheet 2 I just want to show to info for a few of the subgroups, so on worksheet 2 I make a cell reference to worksheet 1 for the member I want, but when I change the autofilters on worksheet 1 the information on worksheet 2 is all messed up. Does anyone know how to make the cell reference on my worksheet 2 stay with the member I desire regardless of the filters used on worksheet 1?

Thanks,
Ketan

[mahju]

Well come to the form

Can you please attach a sample file?

Thanks

Regards

[ketantantod]

Please see the attached. Thanks!