+ Reply to Thread
Results 1 to 3 of 3

extracting data from other worksheets

  1. #1
    Registered User
    Join Date
    07-03-2006
    Posts
    1

    Exclamation extracting data from other worksheets

    How do I extract data from 4 other worksheets to input into one other worksheet?

    e.g. I have Costs and Distance for 4 different Destinations on 4 worksheets respectively. When I type in a Destination (say, Singapore) on a new sheet, I want the Cost and Distance to appear automatically. Different destinations will have different costs and distances. The destinations are in 4 different worksheets, grouped according to continents, together with their respective Costs and Distances.

    I need help in having the correct formulas that will cause the automatic appearance of Cost and Distance when I type in a Destination.

    Thanks!

  2. #2
    Franz Verga
    Guest

    Re: extracting data from other worksheets

    peiwen wrote:
    > How do I extract data from 4 other worksheets to input into one other
    > worksheet?
    >
    > e.g. I have Costs and Distance for 4 different Destinations on 4
    > worksheets respectively. When I type in a Destination (say, Singapore)
    > on a new sheet, I want the Cost and Distance to appear automatically.
    > Different destinations will have different costs and distances. The
    > destinations are in 4 different worksheets, grouped according to
    > continents, together with their respective Costs and Distances.
    >
    > I need help in having the correct formulas that will cause the
    > automatic appearance of Cost and Distance when I type in a
    > Destination.
    >
    >
    > Thanks!


    I think you could use VLOOKUP function. You can check the on line help. If
    you need some more help, please post back here, posting your formula and
    some example data, or if you like you can upload an example file on
    www.savefile.com.


    --
    Hope I helped you.

    Thanks in advance for your feedback.

    Ciao

    Franz Verga from Italy



  3. #3
    Richard Buttrey
    Guest

    Re: extracting data from other worksheets

    On Mon, 3 Jul 2006 02:09:11 -0500, peiwen
    <peiwen.2acyap_1151910609.3316@excelforum-nospam.com> wrote:

    >
    >How do I extract data from 4 other worksheets to input into one other
    >worksheet?
    >
    >e.g. I have Costs and Distance for 4 different Destinations on 4
    >worksheets respectively. When I type in a Destination (say, Singapore)
    >on a new sheet, I want the Cost and Distance to appear automatically.
    >Different destinations will have different costs and distances. The
    >destinations are in 4 different worksheets, grouped according to
    >continents, together with their respective Costs and Distances.
    >
    >I need help in having the correct formulas that will cause the
    >automatic appearance of Cost and Distance when I type in a Destination.
    >
    >
    >Thanks!


    Obvious question, but why maintain four worksheets? If necessary, why
    not just add an extra field for the continent in question and keep all
    data on one sheet.

    Then you could either use Data Filter to see relevant Costs and
    Distances, or a Vlookup formula.

    Rgds

    __
    Richard Buttrey
    Grappenhall, Cheshire, UK
    __________________________

+ 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