Results 1 to 4 of 4

Search keyword in diff sheet and populate new column

Threaded View

sarat47 Search keyword in diff sheet... 11-19-2013, 01:50 PM
sktneer Re: Search keyword in diff... 11-19-2013, 03:27 PM
sarat47 Re: Search keyword in diff... 11-20-2013, 01:00 PM
sktneer Re: Search keyword in diff... 11-20-2013, 01:23 PM
  1. 11-19-2013, 01:50 PM #1
    sarat47 is offline
    Forum Contributor
    Join Date
    10-02-2012
    Location
    india
    MS-Off Ver
    Excel 2010
    Posts
    165

    Search keyword in diff sheet and populate new column

    Hello Everyone!

    In sheet1, I want to search 'StudentName' working in different company (sheet2 contain the list) and then add one column 'Sector' at the end to populate Student working in respective company in another sheet 'Data'.

    My output should be like in sheet 'Data'

    Advance thanks for your help
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Search multiple worksheets for keyword and return all rows with that keyword to new sheet
    By thejesse in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-18-2014, 11:16 AM
  2. Search 2 diff sheets with diff column headers and identify common names, return entire row
    By justin11 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-30-2013, 07:42 PM
  3. [SOLVED] Populate Listbox from 2 columns based on search keyword from text box
    By sivakumar123 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-05-2012, 12:22 AM
  4. Copy keyword from one sheet, find that keyword in cells in column D and paste it under rel
    By vish621979 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-13-2012, 04:02 AM
  5. Search keyword in a column & if any keyword match then cut that full row & paste it
    By computron in forum Excel General
    Replies: 1
    Last Post: 12-27-2010, 08:53 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1