+ Reply to Thread
Results 1 to 3 of 3

Search for more cells in a different sheet and copy another info in the current worksheet

  1. #1
    Registered User
    Join Date
    01-17-2020
    Location
    London, England
    MS-Off Ver
    2016
    Posts
    2

    Search for more cells in a different sheet and copy another info in the current worksheet

    Hello,

    First of all, thank you for your help.
    I tried to find some codes for my problem, but i didnīt found the right one and i wasnīt able to change them.

    I have 500 numbers in an document. It is called ''Idea'' and the sheet is calld TUL.
    The numbers are in colume F.
    The macro should search in another document(Tosearch) with also 500 numbers on one sheet (Current Week), if itīs on this list. In this document the number is in column G.
    If the number is on it, the macro should copy column Z from the same row in the document with the searched numbers in column P.

    I have some macro, but it was only working for one searched word, but not for different words.
    Can you please help me with this problem.

    Thank you very much.
    Last edited by Manu223123; 01-17-2020 at 10:38 PM.

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: Search for more cells in a different sheet and copy another info in the current worksh

    Administrative note

    Welcome to the forum

    missed the yellow banner advising how to get answers faster by posting a sheet ?

    Please take a moment to read it and attach a sheet accordingly.

    Thanks you for helping us help you

  3. #3
    Registered User
    Join Date
    01-17-2020
    Location
    London, England
    MS-Off Ver
    2016
    Posts
    2

    Re: Search for more cells in a different sheet and copy another info in the current worksh

    Ohh Sorry, yeah know i uploaded an example.
    Hope this is ok like this.

    Thank you for your help.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Search for dates and copy specific cells to another sheet
    By rakotonirinas in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-07-2019, 11:50 AM
  2. Replies: 14
    Last Post: 10-29-2015, 07:29 PM
  3. Replies: 0
    Last Post: 05-04-2014, 11:06 PM
  4. [SOLVED] Search values and copy to specific sheet & cells
    By keis386 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-19-2013, 12:24 PM
  5. Replies: 3
    Last Post: 08-16-2012, 03:25 PM
  6. Search multiple worksheets and copy cells to summary sheet
    By crttrlvr in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-09-2012, 03:01 PM
  7. Search header row for common text in cells and copy below rows to new sheet
    By drewship in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-19-2011, 02:23 PM

Tags for this Thread

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