Share via

Extract specific text data into different tabs in a workbook

Anonymous
2022-03-09T16:50:12+00:00

I'm trying to extract specific text data from a master sheet into other specific sheets. I know the word I am looking for and it will have a first and last name that are in the same row but different columns. can anyone help me?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

14 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2022-03-09T17:45:19+00:00

    it is in multiple rows so i need it to find the row. I do know we are looking in column I of the sheet called master

    Was this answer helpful?

    0 comments
  2. DaveM121 891.6K Reputation points Independent Advisor
    2022-03-09T17:38:51+00:00

    Hi Michael

    Do you know the row this data will be in, or do you want the formula to find the row which contains Wilton?

    Was this answer helpful?

    0 comments
  3. Anonymous
    2022-03-09T17:36:58+00:00

    "Wilton" comes from "Master" sheet to the sheet called "Wilton" First name in column "A", the last name is column "B" the word Wilton will land in column "C" which is labeled Precinct

    Was this answer helpful?

    0 comments
  4. Anonymous
    2022-03-09T17:34:24+00:00

    Thank you so very much.

    What is the name of the Master Sheet? Master

    What cells on that sheet do you need to reference, and any other criteria.

    I am looking to pull the word "Wilton" out of one column, Column "I". I am also looking to at the same time pull the first name and last name from the same row as the word Wilton.

    The first name will be from column B and the last name is from column C. Once I have the correct formula for this, I will need to change the word Wilton to 14 other words all in other tabs. Is this making sense?

    Was this answer helpful?

    0 comments
  5. DaveM121 891.6K Reputation points Independent Advisor
    2022-03-09T17:24:28+00:00

    Hi Michael,

    I am Dave, I will help you with this.

    This can be done, can you please provide more information on your requirements.

    What is the name of the Master Sheet?

    What cells on that sheet do you need to reference, and any other criteria.

    Was this answer helpful?

    0 comments