Thanks Thanks:  0
Likes Likes:  0
Page 2 of 2 FirstFirst 12
Results 11 to 13 of 13

Thread: Search and copy problem

  1. #11
    New Member
    Join Date
    Feb 2002
    Posts
    28
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanx this is what i was looking for.
    greetings, Herman

  2. #12
    MrExcel MVP
    Join Date
    Apr 2002
    Location
    Vancouver BC , Canada
    Posts
    6,259
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Might want to read the posting "find in multiple sheets copy in 1 sheet"

    I've posted a solution there that I think may be applicable to your problem as well.

  3. #13
    Legend NateO's Avatar
    Join Date
    Feb 2002
    Location
    Minneapolis, Mn, USA
    Posts
    9,700
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Herman, glad to hear this is working well. Incidentally, I've updated the code with an error trapper in the event that your search results in over 65536 rows, in which case Excel would bomb . Also, it inserts a comment in column A of each row telling you the sheet name and cell that the search term in that particular row came from. Figured this may be of help.

    Nimmy, what's happenin'? I lived in Chilliwack, BC for four years or so. What happend to our Canucks?

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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