Ozgrid Excel Help & Best Practices Forums

Excel Training / Excel Dashboards Reports

Results 1 to 2 of 2

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

  1. #1
    Join Date
    10th April 2013
    Registered Users

    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.


    Excel Video Tutorials / Excel Dashboards Reports

  2. #2
    Join Date
    9th April 2007
    Alstonville, Australia
    Super Moderators

    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

Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Replies: 11
    Last Post: October 27th, 2012, 07:18
  2. Replies: 2
    Last Post: May 17th, 2011, 22:13
  3. Pull data from worksheet matching cell header text
    By redtapegraphics in forum Excel General
    Replies: 2
    Last Post: May 5th, 2011, 03:22
  4. Search a worksheet for an entire range
    By tbmbob in forum Excel General
    Replies: 3
    Last Post: August 8th, 2006, 04:38


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts