Announcement

Collapse
No announcement yet.

Search for one cell of data and pull entire row to another worksheet.

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Search for one cell of data and pull entire row to another worksheet.

    Hi Experts,

    I am a complete newb in macros but have been given a task and have no idea how to do it.

    We have pulled a large amount of data into one excel spreadsheet and am looking to do the following with it.

    I would like to do a search through the entire spreadsheet say by the first 3 digits of a postal code i.e. m5v. I would then like it to grab each row that has an m5v postal code and move all that data to another worksheet.

    My columns used are a - q and the postal code field is in column g across the entire worksheet.


    So let me be fully clear on what I am looking for.

    I need to have the macro search column g for a specified 3 digits i.e. m5v, then grab the entire row of information and store it in another worksheet.

    Any help would be appreciated.

    Thanks,
    Darren

  • #2
    Re: Search for one cell of data and pull entire row to another worksheet.

    hi RCIDarren
    Welcome to the forum
    a search on the forum found one example
    this should get you started and give you an idea of what other infoormation is require to completer the task
    If the solution helped please donate to RSPCA

    Sites worth visiting: Rabbitohs | Excel-it royUK | Excel Matters Rory | Kris' Spreadsheet Solutions | Domenic xl-central | SO The Macro Man | The Smallman

    Comment

    Working...
    X