Results 1 to 5 of 5

Link data from multiple data sheets

Threaded View

  1. #1
    Registered User
    Join Date
    08-31-2009
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    12

    Thumbs up Link data from multiple data sheets

    I am trying to link data from multiple sheets in a file into one sheet. This is the following I want to achieve.

    1) I want to pull data from the tab - Tab 1 (in the attached sheet) from column F only if the column E cell has 3, into the "Plan" Sheet in cell D5. I want all the 3's information from Tab 1 (F12, F14, F16 and F17) to be in the same cell D5 with alt+Enter spacing. The trick is these cells may not be always 3 they can be either 1,2,3. So the function needs to go through the entire range E10:E69 to find where there are 3 in the E column and then return the corresponding data from the F column to the "Plan" sheet in Tab 1.

    I would really appreciate if someone can help me on this, it has been a nightmare to figure this out.

    Thank you friends
    Attached Files Attached Files
    Last edited by gsweta; 09-06-2009 at 02:25 AM.

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