+ Reply to Thread
Results 1 to 4 of 4

Dropdown's to lookup data

  1. #1
    Registered User
    Join Date
    12-19-2007
    Posts
    2

    Dropdown's to lookup data

    Hi all!

    I'm sorry for my bad English but I really need your help to solve my challege.
    I have a workbook, there are three sheets which named "Actual" and "Plan" and "Report" in this workbook. Now, I have to put the data from sheet "Actual" and "Plan" into sheet "Report". I don't know how to explain clealy to help you understand but I mean: First, in sheet "Report", if I choose a value from drop-list at cell C5 (for example I choose Group1) then I choose a value from drop-list at cell E5 (for example I choose T1) then the data of both sheet "Actual" and "Plan" of Group1 at column named T1 will be put in sheet "Report".
    Sorry for this point I can't explain clearly, but you can see the worksheet I've attached to understand what I mean, so you can help me.
    Thanks,
    Attached Files Attached Files
    Last edited by secam; 12-19-2007 at 12:59 PM.

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,487
    Hi,
    No attachment supplied

  3. #3
    Registered User
    Join Date
    12-19-2007
    Posts
    2
    Sorry, I've just attached the file, pls help me.
    Thanks so much,

    Secam.

  4. #4
    Registered User
    Join Date
    01-23-2007
    Posts
    20
    Hi there,

    Ive filled in the formulas under the Plan heading on the Report Sheet.

    Is that what you were after?


    Chris
    Attached Files Attached Files

+ 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