Spreadsheet: 42402d1240984175-excel-enquiry-over-multiple-sheets-sample-1
Sheet: Inquiry

 | User Selects |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Select Code
 | Data group |  | Sub group |  | Data line |  | State |  |  |  | Qtr 1 | Qtr 2 | Qtr 3 | Qtr 4 | Total |  | Operation |  | Project |  | Process |  | Category |  | Object |  | Component |  | Code
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | From | To | From | To | From | To | From | To | From | To | From | To
User example 1 | 2 |  | 1 |  |  |  |  |  |  |  | ? | ? | ? | ? |  |  | 11 | 13 |  |  | 13 | 21 | 17 | 23
User example 2 | 2 |  |  |  | 3 |  |  |  |  |  | ? | ? | ? | ? |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [PHONE]
User example 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [PHONE]
 | Problem: |  | User can randomly select criteria for columns B, C, or D, and M thru R/or S, and the search populates Qrt 1 - 4. Where no criteria is specified, it means 'all'
 |  |  | User may populate all search fields or just 1
 |  |  | The 'State' criteria is probably superfluous - the Operations are unique to individual States, but it would be nice to offer the User the State or the Operation as an input criteria
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 |  | 10 |  | 10 |  | 10 |  | 10 |  | 10
 | 1 |  | 1 |  | 1 |  | Kentucky |  |  |  |  |  |  |  |  |  | 11 |  | 11 |  | 11 |  | 11 |  | 11 |  | 11
 | 2 |  | 2 |  | 2 |  | Ohio |  |  |  |  |  |  |  |  |  | 12 |  | 12 |  | 12 |  | 12 |  | 12 |  | 12
 | 3 |  |  |  | 3 |  | Utah |  |  |  |  |  |  |  |  |  | 13 |  | 13 |  | 13 |  | 13 |  | 13 |  | 13
 | 4 |  |  |  | 4 |  | New York |  |  |  |  |  |  |  |  |  | 14 |  | 14 |  | 14 |  | 14 |  | 14 |  | 14
 |  |  |  |  | 5 |  | Wyoming |  |  |  |  |  |  |  |  |  | 15 |  | 15 |  | 15 |  | 15 |  | 15 |  | 15
 |  |  |  |  | 6 |  | Texas |  |  |  |  |  |  |  |  |  | 16 |  | 16 |  | 16 |  | 16 |  | 16 |  | 16
 |  |  |  |  |  |  | Idaho |  |  |  |  |  |  |  |  |  | 17 |  | 17 |  | 17 |  | 17 |  | 17 |  | 17
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18 |  | 18 |  | 18 |  | 18 |  | 18 |  | 18
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19 |  | 19 |  | 19 |  | 19 |  | 19 |  | 19
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 |  | 20 |  | 20 |  | 20 |  | 20 |  | 20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21 |  | 21 |  | 21 |  | 21 |  | 21 |  | 21
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22 |  | 22 |  | 22 |  | 22 |  | 22 |  | 22
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23 |  | 23 |  | 23 |  | 23 |  | 23 |  | 23
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 24 |  | 24 |  | 24 |  | 24 |  | 24 |  | 24
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25 |  | 25 |  | 25 |  | 25 |  | 25 |  | 25
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 26 |  | 26 |  | 26 |  | 26 |  | 26 |  | 26
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 27 |  | 27 |  | 27 |  | 27 |  | 27 |  | 27
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 28 |  | 28 |  | 28 |  | 28 |  | 28 |  | 28
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 29 |  | 29 |  | 29 |  | 29 |  | 29 |  | 29
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30 |  | 30 |  | 30 |  | 30 |  | 30 |  | 30
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31 |  | 31 |  | 31 |  | 31 |  | 31 |  | 31
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 32 |  | 32 |  | 32 |  | 32 |  | 32 |  | 32
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 33 |  | 33 |  | 33 |  | 33 |  | 33 |  | 33
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 34 |  | 34 |  | 34 |  | 34 |  | 34 |  | 34
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 35 |  | 35 |  | 35 |  | 35 |  | 35 |  | 35
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 36 |  | 36 |  | 36 |  | 36 |  | 36 |  | 36
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 37 |  | 37 |  | 37 |  | 37 |  | 37 |  | 37
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 38 |  | 38 |  | 38 |  | 38 |  | 38 |  | 38
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 39 |  | 39 |  | 39 |  | 39 |  | 39 |  | 39
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 40 |  | 40 |  | 40 |  | 40 |  | 40 |  | 40
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 41 |  | 41 |  | 41 |  | 41 |  | 41 |  | 41
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 42 |  | 42 |  | 42 |  | 42 |  | 42 |  | 42
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 43 |  | 43 |  | 43 |  | 43 |  | 43 |  | 43
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 44 |  | 44 |  | 44 |  | 44 |  | 44 |  | 44
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 45 |  | 45 |  | 45 |  | 45 |  | 45 |  | 45
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 46 |  | 46 |  | 46 |  | 46 |  | 46 |  | 46
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 47 |  | 47 |  | 47 |  | 47 |  | 47 |  | 47
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 48 |  | 48 |  | 48 |  | 48 |  | 48 |  | 48
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 49 |  | 49 |  | 49 |  | 49 |  | 49 |  | 49
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50 |  | 50 |  | 50 |  | 50 |  | 50 |  | 50