+ Reply to Thread
Results 1 to 2 of 2

Macro not working - transfer of data to specific place

  1. #1
    Forum Contributor
    Join Date
    04-21-2006
    Location
    Australia
    MS-Off Ver
    O365 PC Version 2301
    Posts
    122

    Macro not working - transfer of data to specific place

    Hi guys,

    I have an issue with vba code set to transfer data from one sheet into specific place on another sheet. It is a draw for a sporting competition. Basically it is supposed to transfer the teams from a set draw into the weekly draw tab. For some reason the parts setup for 8 teams are not working. I have already used it for one grade with only 6 teams and that worked. I previously used it with two grades of 6 teams and it worked. Now trying with one grade of 8 teams it crashes as soon as it tries to input at week one.

    The macro appears to have been setup only for 6 Team A & B and 8 Team A & B. There are others on the sheet that are not setup at all. Inputs include the days to play on as well as the team name themselves.

    Any help would be appreciated.
    Attached Files Attached Files
    Last edited by Aussie_Striker; 03-18-2017 at 10:28 PM.

  2. #2
    Valued Forum Contributor
    Join Date
    09-19-2008
    Location
    It varies ...
    MS-Off Ver
    Office365 - 64bit
    Posts
    862

    Re: Macro not working - transfer of data to specific place

    I assume it's activated by clicking the button "Transfer All to Weekly Draw"? If so, your protection module is referencing a sheet "References" that doesn't exist so crashes there. Which particular module is the error occurring in?
    MatrixMan.
    --------------------------------------
    If this - or any - reply helps you, remember to say thanks by clicking on *Add Reputation.
    If your issue is now resolved, remember to mark as solved - click Thread Tools at top right of thread.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 4
    Last Post: 03-13-2017, 07:49 AM
  2. [SOLVED] Not working Macro --Distance Function/Macro made a couple of years ago
    By IonutC in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 12-20-2016, 10:33 AM
  3. [SOLVED] help index and match macro not working but formula working??
    By JEAN1972 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-28-2016, 06:37 AM
  4. Hide Columns Macro - Working on Windows not working on Mac OSX
    By bcadar in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-08-2016, 09:05 AM
  5. Replies: 7
    Last Post: 03-18-2015, 03:41 PM
  6. Replies: 1
    Last Post: 05-27-2014, 02:40 PM
  7. [SOLVED] Macro to merge duplicate rows unique values - current macro not working
    By aimeecrystalaid in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-06-2013, 03:42 PM

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