+ Reply to Thread
Results 1 to 1 of 1

Searching all worksheets and copying rows onto designated worksheet

  1. #1
    Registered User
    Join Date
    12-02-2010
    Location
    Shanghai China
    MS-Off Ver
    Excel 2003
    Posts
    9

    Post Searching all worksheets and copying rows onto designated worksheet

    Hi,

    I have an excel sheet with 20 plus sheets filled by people from different parts of the world. Users enter their respective names and countries on 19 out of the 20 sheets.
    The last sheet will contain all records from users of the same country.

    I'm trying to write a macro which will compare cell "C3" of the each of the first 19 sheets ("C3" is a validation list of all countries), with cell "D6" of the last sheet.

    If C3 = D6, then all non empty cells between starting from B9:M9 will be copied from sheets (1-19) to sheet 20. The macro will look for the next empty row on sheet 20 and paste matching records to avoid overwriting previous matches.

    The problem is that the macro is only copying from one sheet, and keeps on looping... Please help!
    Thanks in advance!

    Please see code below:

    Please Login or Register  to view this content.
    Last edited by shoesterix; 12-02-2010 at 05:39 AM. Reason: Forgot to add problem

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1