+ Reply to Thread
Results 1 to 3 of 3

If sheet1 cell contains specific text, copy text from *different* sheet1 cell to sheet2

  1. #1
    Registered User
    Join Date
    04-16-2012
    Location
    Colorado
    MS-Off Ver
    Excel 2010
    Posts
    2

    If sheet1 cell contains specific text, copy text from *different* sheet1 cell to sheet2

    I may be asking too much, but is there a formula (seems like I should be able to use an IF THEN) that will do the following:
    - check a range of cells on sheet1 (F2:F30) and find cells where text=firstname
    - if text=firstname, then copy text from corresponding row, DIFFERENT column (C) and paste to sheet2

    Basically, I have two sheets in my workbook. On Sheet1 is a list of projects (column C) and the point person's name (column F)
    On Sheet2 is a list of point person names (column A) and I want to copy over (into column B, Sheet2) the name of each project to which the person has been assigned on Sheet1

    This probably also requires a macro to add rows, and that is why I stated at the beginning that I may be asking too much.

    thanks very much for any ideas!
    Last edited by nikkiL; 04-16-2012 at 10:25 PM. Reason: changed cell references in post to match example file uploaded

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,474

    Re: If sheet1 cell contains specific text, copy text from *different* sheet1 cell to sheet

    Supply a sample workbook.
    Upload a workbook

  3. #3
    Registered User
    Join Date
    04-16-2012
    Location
    Colorado
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: If sheet1 cell contains specific text, copy text from *different* sheet1 cell to sheet

    Sorry about that! Here's an example.
    Forum Example.xlsx

+ Reply to Thread

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