Results 1 to 10 of 10

Copy and paste from one sheet to another if the criteria met

Threaded View

  1. #1
    Forum Contributor
    Join Date
    11-12-2007
    Location
    Germany
    MS-Off Ver
    2007
    Posts
    472

    Copy and paste from one sheet to another if the criteria met

    Hello every one,
    I have a dictionary for which’s words I want to find poem verse pairs as references. I want to add 3 different verse pairs of poems as reference to each word from my wordlist. There are two worksheets:
    “ws-1” col. A contains those words I want to find 3 verse pairs as ref. for (ca. 65000 rows)
    And
    “ws-ref” col. A and B contain verse pairs and col. D has start value “0”(ca. 80 000 rows)
    I need a code which reads the word in column A “ws-1” and searches for that in col. A and B of “ws-ref”. If the searched word exits in content of A or B of “ws-ref” then this is an acceptable result. Now three different results from all the found ones should be copy and pasted from “ws-ref” to “ws-1” and 1 should be added to col. D value after each completed pasting. Adding 1 is for the purpose to be able to know latter how many times that specific verse pair was chosen and copied as reference. Criteria for choosing 3 from many results should be the lowest value in col. D “ws-ref”.
    1rst result should be copy pasted from “ws-ref” A,B,C,D to “ws-1” col. F,G,H,I (*only if F and G empty)
    2nd result should be copy pasted from “ws-ref” A,B,C,D to “ws-1” col. J,K,L,M(*only if J and K empty)
    3rd result should be copy pasted from “ws-ref” A,B,C,D to “ws-1” col. N,O,P,Q (*only if N and O empty)
    I will be very grateful for each help.
    Attached Files Attached Files
    Last edited by wali; 12-12-2009 at 04:25 PM.

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