+ Reply to Thread
Results 1 to 9 of 9

Need help with macro that will FIND, COPY & PAste to different sheet :)

  1. 07-26-2012, 11:14 AM #1
    MeloReese
    MeloReese is offline
    Registered User
    Join Date
    07-26-2012
    Location
    bxu
    MS-Off Ver
    Excel 2007
    Posts
    6

    Need help with macro that will FIND, COPY & PAste to different sheet :)

    Hi All,

    First post here, been having trouble finding what I need. Im really a newbie to this stuff

    Please find attached excel. It contains all the infos for the macro. :D



    Thanks!!
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 07-26-2012, 11:49 AM #2
    nilem
    nilem is offline
    Forum Expert nilem's Avatar
    Join Date
    10-22-2011
    Location
    Ufa, Russia
    MS-Off Ver
    2013
    Posts
    3,377

    Re: Need help with macro that will FIND, COPY & PAste to different sheet :)

    Hi MeloReese, try it
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  3. 07-26-2012, 05:04 PM #3
    MeloReese
    MeloReese is offline
    Registered User
    Join Date
    07-26-2012
    Location
    bxu
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: Need help with macro that will FIND, COPY & PAste to different sheet :)

    WOW! Thank you!!! I'm Amazed at how well It works
    Reply With QuoteRegister To Reply
  4. 07-30-2012, 04:09 PM #4
    MeloReese
    MeloReese is offline
    Registered User
    Join Date
    07-26-2012
    Location
    bxu
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: Need help with macro that will FIND, COPY & PAste to different sheet :)

    Hi Nilem,

    Sorry for the late reply. Kindly see attached excel for my follow up question .. Hope you can help me on this i would really appreciate your help.. Thank you in advance




    Melo
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  5. 07-30-2012, 05:52 PM #5
    nilem
    nilem is offline
    Forum Expert nilem's Avatar
    Join Date
    10-22-2011
    Location
    Ufa, Russia
    MS-Off Ver
    2013
    Posts
    3,377

    Re: Need help with macro that will FIND, COPY & PAste to different sheet :)

    try
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  6. 08-01-2012, 09:28 AM #6
    MeloReese
    MeloReese is offline
    Registered User
    Join Date
    07-26-2012
    Location
    bxu
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: Need help with macro that will FIND, COPY & PAste to different sheet :)

    Hi Nilem,


    im havin an error.......Run-time error '9' Subscript out of range....when i debug it this was highlighted x(.Item(y(i, 1)), .Item(y(i, 3))) = y(i, 6)

    Please Login or Register  to view this content.
    Last edited by Cutter; 08-01-2012 at 01:13 PM. Reason: Added code tags
    Reply With QuoteRegister To Reply
  7. 08-01-2012, 10:29 AM #7
    nilem
    nilem is offline
    Forum Expert nilem's Avatar
    Join Date
    10-22-2011
    Location
    Ufa, Russia
    MS-Off Ver
    2013
    Posts
    3,377

    Re: Need help with macro that will FIND, COPY & PAste to different sheet :)

    I could not reproduce the error. Perhaps you have changed the structure of the data in your file? If yes, please show your new file.
    Reply With QuoteRegister To Reply
  8. 08-01-2012, 01:13 PM #8
    Cutter
    Cutter is offline
    Forum Expert Cutter's Avatar
    Join Date
    05-24-2004
    Location
    Ontario,Canada
    MS-Off Ver
    Excel 2010
    Posts
    6,451

    Re: Need help with macro that will FIND, COPY & PAste to different sheet :)

    @ MeloReese

    Welcome to the forum.

    Please notice that code tags have been added to your post(s). The forum rules require them so please keep that in mind and add them yourself whenever showing code in any of your future posts. To see instructions for applying them, click on the Forum Rules button at top of the page and read Rule #3.
    Thanks.
    Reply With QuoteRegister To Reply
  9. 08-13-2012, 08:03 AM #9
    MeloReese
    MeloReese is offline
    Registered User
    Join Date
    07-26-2012
    Location
    bxu
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: Need help with macro that will FIND, COPY & PAste to different sheet :)

    oppss sorry... anyways thank nilem !!!
    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