Hi there,
New to this forum and I am hoping to get some help with some excel questions. Hopefully I can be as clear as possible so I won't waste your time.

I have a list of data on Sheet 1 and forms that I have created on Sheet 2
The problem is the following :
When I filter data on Sheet 1, the forms (Sheet 2) still access the same cells (even the ones that aren't filtered) on Sheet 1.
I would like Sheet 2 (forms) to only gather the filtered data from Sheet 1.

Thanks for your help