Hi, i need help constructing a search model database. The scenario is below:
A user enters a season number into the desired cell/field.
Using the season number, the worksheet will retrieve all available data from the imported data and display selective data.
The book contains two sheets: the imported data and the search page.
Here is the sample data:
Here is a sample search page:
[HTML removed by Von Pookie]
A user enters a season number into the desired cell/field.
Using the season number, the worksheet will retrieve all available data from the imported data and display selective data.
The book contains two sheets: the imported data and the search page.
Here is the sample data:
| StarTrek.xml | |||||||
|---|---|---|---|---|---|---|---|
| A | B | C | D | E | |||
| 1 | Title | Season | Air Date | Stardate | Synopsis | ||
| 2 | 11001001 | 1 | 1/2/1988 | 41365.9 | The Bynars take control of Enterprise. | ||
| 3 | A Fistful of Datas | 6 | 9/11/1992 | 46271.5 | Data becomes the villain in a Holodeck malfunction. | ||
| 4 | A Matter of Honor | 2 | 6/2/1989 | 42506.5 | Riker serves as first officer on board a Klingon ship. | ||
| 5 | A Matter of Perspective | 3 | 12/2/1990 | 43610.4 | Riker is accused of murder. | ||
| 6 | A Matter of Time | 5 | 18/11/1991 | 45349.1 | The Enterprise plays host to a visitor from the future. | ||
| 7 | All Good Things... Part I | 7 | 23/05/1994 | 47988.1 | Picard tries to prevent the destruction of humanity. | ||
| 8 | All Good Things... Part II | 7 | 23/05/1994 | 47988.1 | Picard tries to prevent the destruction of humanity. | ||
| 9 | Allegiance | 3 | 26/03/1990 | 43714.1 | A replica of Picard replaces him on the Enterprise. | ||
| 10 | Angel One | 1 | 25/01/1988 | 41636.9 | The crew travels to a planet with a matriarchal society. | ||
| 11 | Aquiel | 6 | 1/2/1993 | 46461.3 | Geordi falls in love with an alien murder suspect. | ||
| 12 | Attached | 7 | 8/11/1993 | 47304.2 | Picard and Beverly face their feelings for each other. | ||
| 13 | Birthright, Part I | 6 | 22/02/1993 | 46578.4 | Worf and Data set out on journeys to find their fathers. | ||
| 14 | Birthright, Part II | 6 | 1/3/1993 | 46579.2 | Worf risks his life to inspire younger Klingons. | ||
| 15 | Bloodlines | 7 | 2/5/1994 | 47829.1 | Picard learns he has a son. | ||
| 16 | Booby Trap | 3 | 30/10/1989 | 43205.6 | The Enterprise is ensnared in an intergalactic booby trap. | ||
| 17 | Brothers | 4 | 8/10/1990 | 44085.7 | Data faces his creator and his evil brother, Lore. | ||
| 18 | Captain's Holiday | 3 | 2/4/1990 | 43745.2 | Picard's vacation is interrupted by time travelers. | ||
| 19 | Cause and Effect | 5 | 23/03/1992 | 45652.1 | The Enterprise is trapped in a time warp. | ||
| 20 | Chain of Command, Part I | 6 | 14/12/1992 | 46357.4 | After being reassigned, Picard is taken hostage. | ||
| 21 | Chain of Command, Part II | 6 | 21/12/1992 | 46360.8 | The crew attempts to rescue Picard from Cardassians. | ||
| 22 | Clues | 4 | 11/2/1991 | 44502.7 | Data lies to the crew. | ||
| 23 | Code of Honor | 1 | 12/10/1987 | 41235.25 | Tasha is kidnapped. | ||
StarTrek | |||||||
Here is a sample search page:
[HTML removed by Von Pookie]
