+ Reply to Thread
Results 1 to 5 of 5

Look up and Transfer Data

  1. #1
    Lost in Sport
    Guest

    Look up and Transfer Data

    I have multiple spreadsheets that I want to move certain information from to
    get all my info into one spreadsheet. Is there anyway to search mutiple
    spreadsheets by a column like "Area" and tell it to retrive another
    multiple colums like "Sport", "venue", "day", "date" etc then post it into a
    corresponding column in another
    worksheet by matching "Area"??
    also information input into seperate spread sheets should also update the
    spreadsheet with merged ino?


  2. #2
    Dave O
    Guest

    Re: Look up and Transfer Data

    Your answer is almost certainly "Yes" but in order to help we'd need an
    example of your data. Functions such as VLOOKUP can easily summarize
    data, but the formula you'd use depends on the nature and layout of the
    data.


  3. #3
    Hulkascooby
    Guest

    Re: Look up and Transfer Data

    Ok
    How do I get a sample of the worksheet to you?


    "Dave O" wrote:

    > Your answer is almost certainly "Yes" but in order to help we'd need an
    > example of your data. Functions such as VLOOKUP can easily summarize
    > data, but the formula you'd use depends on the nature and layout of the
    > data.
    >
    >


  4. #4
    Dave O
    Guest

    Re: Look up and Transfer Data

    Please describe the layout of your data: what data appears on what
    tabs, what column headers, etc.
    That way the entire newsgroup can suggest ideas.


  5. #5
    Hulkascooby
    Guest

    Re: Look up and Transfer Data

    Pob's Area Ward S&R Area Officer/Contact
    Person Venue Sport Category Coach(es) Start Date Finish Date Day Start
    Time Finish Time Age-group Avg Att (Cur Per) Known Development
    Activity Observations Work To Cease (Reason) Work To Continue (Reason) Action
    (Obs) Recommendations Action (Rec) Lead Timescales
    These are the colum headings there is a significant amount of data to sort .
    I am trying to sort it by area for one sheet and by sport for another is this
    any clearer?

    "Dave O" wrote:

    > Please describe the layout of your data: what data appears on what
    > tabs, what column headers, etc.
    > That way the entire newsgroup can suggest ideas.
    >
    >


+ 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