This might be 'easy', but my brain is in the wrong gear....
Sheet 1 is a list, about 600 records of 24 fields.
Sheet 2 contains columns 1 & 2 of sheet 1, (put there by formulas in sheet 2 of the type = sheet1!a1, sheet1!b1, etc.) plus about 50 columns of stuff not on sheet 1.
What I want is this: if I filter in sheet 1 on column x, the only records displayed on sheet 2 are to be the ones satisfied by the filter criteria on sheet 1.
I suspect the answer(s) involve one or more of =Indirect, =Offset or =VLookup, but brain still in wrong gear.
A gentle shove in the right direction, please?