+ Reply to Thread
Results 1 to 1 of 1

Pull Data from a worksheet to a cover worksheet

Hybrid View

  1. #1
    Registered User
    Join Date
    02-19-2009
    Location
    Durham, NC
    MS-Off Ver
    Excel 2003
    Posts
    1

    Pull Data from a worksheet to a cover worksheet

    (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
    Last edited by VBA Noob; 02-19-2009 at 05:31 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1