Hi,

Is there a way to get a value to stay when you lookup a value on another sheet and then filter that sheet? Currently if I filter the source obviously the records stay are only the ones which are in that filter Im after all records regardless of if I filter the source or not.

Thanks