+ Reply to Thread
Results 1 to 1 of 1

Retrieve Data

  1. #1
    Registered User
    Join Date
    02-14-2009
    Location
    Malaysia
    MS-Off Ver
    Excel 2003
    Posts
    6

    Retrieve Data

    Sorry if this is a basic question.

    In my workbook I have 1 sheet that call Database. Where the info is there.

    Then I have 9 sheet that contain 10 form in each sheet.

    What I want to do is:

    1. I fill in all the info in Database sheet. (not a problem )
    2. I want to retrieve the data from the Database into the form in the other sheet for example into sheet GA.
    3. To do this I just want to enter the Series Number and then all the data will fill automatic in the appropriate column. (All column at the top of the said form)

    May I know what are the formula that i have to use?

    In the attachment I just use '=' formula but that will be high risk because the data quite a lot.

    Thank you....
    Attached Files Attached Files
    Last edited by abusuffian; 02-16-2011 at 09:31 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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