+ Reply to Thread
Results 1 to 21 of 21

Duplicating Entries

Hybrid View

  1. #1
    Registered User
    Join Date
    01-06-2013
    Location
    San Diego
    MS-Off Ver
    Excel 2007
    Posts
    11

    Re: Duplicating Entries

    The worksheet would not work when I loaded another spreadsheet which records the scores.

    Mike

  2. #2
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,327

    Re: Duplicating Entries

    Quote Originally Posted by eznoh View Post
    The worksheet would not work when I loaded another spreadsheet which records the scores.
    Hard to say without seeing the offening workbook, but the macro is a worksheet change event so much be placed in the code for the sheet and the ranges need to be updated if moved from the original.
    HTH
    Regards, Jeff

  3. #3
    Registered User
    Join Date
    01-06-2013
    Location
    San Diego
    MS-Off Ver
    Excel 2007
    Posts
    11

    Re: Duplicating Entries

    If I open the two different spreadsheets with 2 separate instances of Excel, why should the macros interfere with each other?

  4. #4
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,327

    Re: Duplicating Entries

    Quote Originally Posted by eznoh View Post
    If I open the two different spreadsheets with 2 separate instances of Excel, why should the macros interfere with each other?
    You might want to give some explanation here.

    I don't see a macro in here that matches what has been done in this thread.

    Is this question/query different than the rest of this thread?

  5. #5
    Registered User
    Join Date
    01-06-2013
    Location
    San Diego
    MS-Off Ver
    Excel 2007
    Posts
    11

    Re: Duplicating Entries

    Sorry,attached is what was given to me here. By itself it works but when I run it with the previously attached spreadsheet, it works for a short time then stops working.
    Attached Files Attached Files

  6. #6
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Duplicating Entries

    Jeff's point is...the code you reference
    what was given to me here
    is NOT in your most recent upload.
    I don't see a macro in here that matches what has been done in this thread.
    So, answer his question
    Is this question/query different than the rest of this thread?
    Additionally I don't see a worksheet that resembles what we've been addressing. What worksheet are you trying to run the code against?
    John

    If you have issues with Code I've provided, I appreciate your feedback.

    In the event Code provided resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1