Closed Thread
Results 1 to 5 of 5

Create tab by searching data from one tab using data from another

  1. #1
    Registered User
    Join Date
    01-13-2014
    Location
    Mammoth Lakes, CA
    MS-Off Ver
    Excel 2010
    Posts
    9

    Create tab by searching data from one tab using data from another

    I need to search the beginning of all of the numbers in the apn column on Tab B with the numbers from the APN 1 column. When a match is found then that row will be copied to a new tab named after the Description row on the Tab A tab.
    Attached Files Attached Files

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

    Re: Create tab by searching data from one tab using data from another

    Welcome to the Forum, unfortunately:

    This is a triplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

    Thread Closed.

    http://www.excelforum.com/excel-form...m-another.html

  3. #3
    Registered User
    Join Date
    01-13-2014
    Location
    Mammoth Lakes, CA
    MS-Off Ver
    Excel 2010
    Posts
    9

    Re: Create tab by searching data from one tab using data from another

    Sorry I just did not know which group to post it under.

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

    Re: Create tab by searching data from one tab using data from another

    Please read forum rules - Reading this might also be of use

  5. #5
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Create tab by searching data from one tab using data from another

    Ok. So pls stop posting and take some minutes to read forum rules in which you agreed when you sign in the forum.

    Thread closed.
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Create tab by searching data from one tab using data from another
    By MyMammothTech in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-17-2014, 04:19 PM
  2. Create tab by searching data from one tab using data from another
    By MyMammothTech in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-17-2014, 04:32 AM
  3. Replies: 0
    Last Post: 07-26-2013, 01:27 PM
  4. [SOLVED] Micro for Searching Data from One FILE and perform action if the Data is Found.
    By atthershabbir in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 07-01-2013, 03:26 AM
  5. Searching data in 1 row, giving back data from column thats left to searched data
    By AmiGoCS in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-29-2012, 05:16 PM

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