+ Reply to Thread
Results 1 to 3 of 3

Need macro to find data rows and copy to another worksheet.

  1. 10-22-2009, 07:08 PM #1
    n2lectual
    n2lectual is offline
    Registered User
    Join Date
    03-19-2008
    Posts
    28

    Question Need macro to find data rows and copy to another worksheet.

    Here is my project:
    Worksheet “Booking Sht” cell J21, will enter a numeric or alpha numeric booking number, example: NAB 123456.
    From this cell entry I need a Macro to look at Worksheet “Master” column R5:R5000 for all cells containing this number (NAB 123456) and capture all rows A5:AE5000 that correspond to it (might be as many as 150 rows associated with this number) and populate them into Worksheet “Compile” A5:AE5000. The goal is to : out of spread sheet of approx. 5,000, rows sort out only rows of information pertaining to one booking number into its own spreadsheet for further processing.

    Can this be done? and how? Excel 2002. Thanks.
    Reply With QuoteRegister To Reply
  2. 10-22-2009, 10:31 PM #2
    JBeaucaire
    JBeaucaire is offline
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Need macro to find data rows and copy to another worksheet.

    You can do this with an AUTOFILTER pretty simply, no macro needed...or you can record a macro of you applying an autofilter and then just copying the remaining visible data over to the other sheet.

    Ever worked with the Data > Filter > AutoFilter?
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)
    Reply With QuoteRegister To Reply
  3. 10-23-2009, 04:07 AM #3
    royUK
    royUK is offline
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Need macro to find data rows and copy to another worksheet.

    Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
    To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1