Results 1 to 6 of 6

Search for a value and if the value is found copy the whole row. And repeat the proces

Threaded View

  1. #1
    Registered User
    Join Date
    08-13-2012
    Location
    Amsterdam
    MS-Off Ver
    Excel 2010
    Posts
    4

    Search for a value and if the value is found copy the whole row. And repeat the proces

    Hello,

    I am trying to do two things

    First in the sheet "All Numbers" using the value in column A, search this value in the sheet "internal numbers" in column A.
    If the value is found in the sheet "internal numbers" write the word "OCCUPIED" in column E of the sheet "All Numbers"
    Else if the value is not found in the sheet "internal numbers" write the word "FREE" in column E of the sheet "All Numbers" and repeat for all the rows in sheet "All numbers""until the value in column A is empty

    Second
    First in the sheet "All Numbers" using the value in column A, search this value in the sheet "internal data" in column A.
    If the value is found in the sheet "internal data" copy the whole row (A:AX) total of 50 columns from the sheet "internal data" and append it to the row "All numbers" from column F ( so column A from "internal data" becomes colum F in sheet "All numbers"
    Else if the value is not found in the sheet "internal numbers" goto the next row and repeat for all the rows in sheet "All numbers""until the value in column A is empty.


    Many thanks in advance


    Regards Kevin
    Attached Files Attached Files
    Last edited by beamonemo; 08-13-2012 at 01:19 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