+ Reply to Thread
Results 1 to 3 of 3

Code not copying to extra sheet

  1. #1
    Registered User
    Join Date
    05-22-2019
    Location
    london
    MS-Off Ver
    Office 365
    Posts
    85

    Code not copying to extra sheet

    Hi.

    I have the below code but I can't figure out why its no longer copying to worksheet raw source anymore. I plug the details into the Job input screen worksheet but it only applies the copy and paste to 'all jobs' and not 'Raw source' It was working previously.


    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by davesexcel; 11-19-2021 at 08:52 AM.

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

    Re: Code not copying to extra sheet

    There is no data in the workbook and it is exiting the macro because cell I2 is blank. You also didn't have the button linked to the code above. Perhaps provide a file that has some data in it and describe what it's doing versus what it should be doing. e.g. did you get the message saying "No sheet name" or did something else happen?
    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.

  3. #3
    Registered User
    Join Date
    05-22-2019
    Location
    london
    MS-Off Ver
    Office 365
    Posts
    85

    Re: Code not copying to extra sheet

    Hi MatrixMan

    I've managed to fix the problem. Many thanks for your reply.

+ 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. Macro is copying an extra unneeded row
    By theglitch in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-27-2016, 02:04 PM
  2. [SOLVED] Extra space or spaces in Text in Forum Post. BB Code for extra space ?
    By Doc.AElstein in forum The Water Cooler
    Replies: 21
    Last Post: 03-02-2016, 02:59 PM
  3. [SOLVED] VBA code required to insert extra/New sheets with existing sheet data
    By mchilapur in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-22-2015, 01:52 AM
  4. [SOLVED] Code from tigeravatar ,Copying data from one sheet and copying it
    By DanielRay in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 12-07-2012, 03:07 PM
  5. Replies: 8
    Last Post: 08-27-2012, 04:37 PM
  6. Copy Extra Columns When copying Sheets
    By aftabn10 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-01-2011, 08:10 PM
  7. Copying the sheet code
    By Obfuscated in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-25-2009, 07:24 PM

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