(Note: Formatting changes when I post, but if you need a example here is the link to it: http://www.trianglelandscape.biz/workbook.xls
I need a little help and have exhausted all of my resources of the people I know and from google/yahoo.
I have a workbook I created holding data in multiple worksheets.
Each worksheet is named according to their master number: (Ex. Master 0 - worksheet is named Master 0)
Then each column is named 0 through 9
Each row is set up of either an odd number or even number (and is formated like this :
Master Sheet 3
----------------------------------------------------------------
| | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 |
----------------------------------------------------------------
| | # | | | | | | | | | |
| | # | | | | | | | | | |
| 1 | # | | | | | | | | | |
| | # | | | | | | | | | |
----------------------------------------------------------------
----------------------------------------------------------------
| | | | | | | | | | | 1 |
| 3 | | | | | | | | | | 4 |
| | | | | | | | | | | 5 |
| | | | | | | | | | | 13 |
----------------------------------------------------------------
----------------------------------------------------------------
| | | | | | | | | | | |
| | | | | | | | | | | |
| 5 | | | | | | | | | | |
| | | | | | | | | | | |
----------------------------------------------------------------
----------------------------------------------------------------
| | | | | | | | | | | |
| 7 | | | | | | | | | | |
| | | | | | | | | | | |
| | | | | | | | | | | |
----------------------------------------------------------------
----------------------------------------------------------------
| | | | | | | | | | | |
| | | | | | | | | | | |
| 9 | | | | | | | | | | |
| | | | | | | | | | | |
----------------------------------------------------------------
And then on a cover page the user fills in blanks and clicks search and it displays the results.
User Cover Page Example:
__________ _________________
Master Number | 3 | | Search Button |
------------ -------------------
___________
Control Number | 9 |
-------------
___________
Change Number | 3 |
-------------
And then it displays the results on same page as follows:
Displayed Results: ___________________
| 1 |
----------------------
| 4 |
----------------------
| 5 |
----------------------
| 13 |
----------------------
----------------------
| Clear Results |
----------------------
Is this even possible? Or can someone point me to a program that can do the above?
Thanks in advance for all help
Bookmarks