Results 1 to 4 of 4

Thread: Search for names in a column and row copying purposes

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Member
    Join Date
    Nov 2012
    Posts
    47
    Rep Power
    0

    [Solved] Search for names in a column and row copying purposes

    Hi all,
    I wrote in another forum, but so far no solution to my problem, I need a macro. Please support by your side. Here's the problem:
    I have a workbook with several sheets, one main, I found some code, but they were looking at only one sheet, which does not work for me.
    So I have over 20,000 rows in each sheet A: H, how can you make it so that sheet14 (this is the example) by writing a name in cell A1 (sheet14) and press the blue button (Sheet14), to search all other sheets in columns D and stress when you find (and was several times) to copy the whole, entire rows of information for that name.
    Attached Files Attached Files
    Last edited by k0st4din; 03-26-2013 at 12:37 PM.

Similar Threads

  1. Replies: 1
    Last Post: 06-12-2013, 07:42 PM
  2. Highlight Active Cell’s Row and Column
    By Transformer in forum Tips, Tricks & Downloads (No Questions)
    Replies: 0
    Last Post: 05-17-2013, 12:32 AM
  3. Column to Row and Row to Column
    By lokvan in forum Excel Help
    Replies: 1
    Last Post: 11-30-2012, 09:30 AM
  4. Copy Row To A New Sheet If A Value Found In Adjacent Column
    By Rajesh Kr Joshi in forum Excel Help
    Replies: 4
    Last Post: 08-17-2012, 05:42 PM
  5. Find Last Used Row In Column
    By Rasm in forum Excel and VBA Tips and Tricks
    Replies: 2
    Last Post: 06-04-2012, 07:40 AM

Posting Permissions

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