Results 1 to 5 of 5

Search, Copy and Paste

Threaded View

  1. #1
    Registered User
    Join Date
    02-26-2004
    Location
    philippines
    Posts
    73

    Search, Copy and Paste

    Guys,

    Can anyone help me create a macro that do search, copy and paste? I tried searching for an existing one but there's no macro that matches to what I need. Basically, the macro needs to look in sheet2 column B, the data that it needs to look for is in sheet1 column a, once it finds the data in sheet2 column B, the original search criteria needs to be paste starting in sheet3 A1 while all the found data needs to be paste in column B. It will then proceed to look for the next data in sheet1 column once it's done searching on the first item. I can't even think how to start with this one, it's too complicated for me. I attached a sample data. The search data is in sheet2 and the lookup data is in sheet1.
    Attached Files Attached Files
    Last edited by japorms; 11-21-2008 at 10:49 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