Results 1 to 11 of 11

Copy rows

Threaded View

  1. #1
    Registered User
    Join Date
    06-17-2009
    Location
    Paris, France
    MS-Off Ver
    2007
    Posts
    6

    Copy rows

    Hi guys,

    First of all, I would like to say that I've done some research before posting here. I know similar questions have already been asked, but I just couldn't get every thing to work.

    So I'm doing a project on a survey for my statistics classes, for which I received a few spreadsheet to work with. I have this "individu" spreadsheet that contains 14045 entries (one for each person interviewed) and this "kish" spreadsheet that contains 5799 entries (one for each person from the "individu" sheet that responded to some extra questions in the survey). Problem is that I'm mostly interested in the answers displayed in the "kish" spreadsheet, but I want to be able to use the data that is displayed in the "individu" spreadsheet.

    What I want to do is to copy complete rows from the "individu" spreadsheet to the "kish" spreadsheet that obey to two rules:

    - the "IDENT" value of the row in "individu" must match the "IDENT" value of the corresponding row in "kish"

    - the "NO" value of the row in "individu" must match the "NO" value of the corresponding row in "kish"

    What should I do?

    Thanks in advance!

    OBS: tried to upload the excel file, but it exceeds 7 MB and I keep getting an error when trying to upload it in a zip file, so I uploaded screenshots from each of the spreadsheets!
    Attached Images Attached Images
    Last edited by Cadmium; 01-12-2010 at 05:10 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