CONFUSED_AS_USUAL
Board Regular
- Joined
- Jul 6, 2017
- Messages
- 59
Hi,
I have watched a few a videos and read some on this subject. Unfortunately, none seems to do what I would like unless limited to 1 field search .
Does anyone have an “out of the box” template that will allow me to:
1. Dump large amount of data into Sheet 1. Headers in Row 1.
2. Sheet 2 would have all the headers in Sheet 1 that will allow filtering on one or multiple fields. These would also be in Row 1
3. All data that is a match or partial match would appear Sheet 2 starting on Row 2.
4. Would have a master clear button.
Rules:
1. Partial filtering by field is allowed. IE: Yellow would be picked up by just typing Yel (along with anything else that contains Yel)
2. Would also allow for a second or third search within the same filter. IE: Yel Ba 15 (would return Yellow Ball 15OZ)
3. Does not need to be case sensitive.
4. Would allow for simple mathematical formula. IE: = , > or < in fields that are numeric.
5. All is returned as you are typing.
If not, how difficult would it be to create ?
Any input would be gratefully appreciated.
I have watched a few a videos and read some on this subject. Unfortunately, none seems to do what I would like unless limited to 1 field search .
Does anyone have an “out of the box” template that will allow me to:
1. Dump large amount of data into Sheet 1. Headers in Row 1.
2. Sheet 2 would have all the headers in Sheet 1 that will allow filtering on one or multiple fields. These would also be in Row 1
3. All data that is a match or partial match would appear Sheet 2 starting on Row 2.
4. Would have a master clear button.
Rules:
1. Partial filtering by field is allowed. IE: Yellow would be picked up by just typing Yel (along with anything else that contains Yel)
2. Would also allow for a second or third search within the same filter. IE: Yel Ba 15 (would return Yellow Ball 15OZ)
3. Does not need to be case sensitive.
4. Would allow for simple mathematical formula. IE: = , > or < in fields that are numeric.
5. All is returned as you are typing.
If not, how difficult would it be to create ?
Any input would be gratefully appreciated.