Results 1 to 10 of 19

Thread: data transfer does not match up

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Senior Member
    Join Date
    Jul 2013
    Posts
    102
    Rep Power
    13
    Thanks Admin

    Works great...if I want to say just use All and not Day,Afternoon and Night individually what part of the code would I Comment out (just in case I want to use again)....saves deleting this part of the code

    Thanks again

  2. #2
    Administrator Admin's Avatar
    Join Date
    Mar 2011
    Posts
    1,123
    Rep Power
    10
    Hi

    It's already considering the shift. See these part of the code

    Code:
    If Shift = "all" Then 'all
        CREATE_OUTPUT i, LB
    ElseIf Data(i, 2) = Shift Then 'match shift
        CREATE_OUTPUT i, LB
    End If
    Cheers !

    Excel Range to BBCode Table
    Use Social Networking Tools If You Like the Answers !

    Message to Cross Posters

    @ Home - Office 2010/2013/2016 on Win 10 (64 bit); @ Work - Office 2016 on Win 10 (64 bit)

Similar Threads

  1. Replies: 5
    Last Post: 09-27-2013, 05:47 AM
  2. Replies: 6
    Last Post: 08-25-2013, 12:35 PM
  3. Replies: 7
    Last Post: 07-26-2013, 06:34 PM
  4. How To Move Transfer Or Copy Data To A Protected Sheet
    By rich_cirillo in forum Excel Help
    Replies: 7
    Last Post: 07-13-2013, 06:52 PM
  5. Excel to Excel Data transfer without opening any of the files(source or target)
    By Transformer in forum Excel and VBA Tips and Tricks
    Replies: 14
    Last Post: 08-22-2012, 10:57 AM

Posting Permissions

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