Page 2 of 2 FirstFirst 12
Results 11 to 15 of 15

Thread: Need HELP with code auto move whole row to new worksheet based on data

  1. #11
    New Member
    Join Date
    Feb 2018
    Posts
    9
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Need HELP with code auto move whole row to new worksheet based on data

    Quote Originally Posted by mumps View Post
    You are very welcome.
    Hi mumps you were helping me yesterday with my code issues. I wanted to move a sheet from outstanding to completed and you gave me a macro which worked brilliant and now today when in work I went
    to use the spreadsheet for some reason its not working and I cant understand why, do you have any clues I think it is excel 2016 I am using

  2. #12
    Board Regular mumps's Avatar
    Join Date
    Apr 2012
    Location
    Toronto, Canada
    Posts
    8,248
    Post Thanks / Like
    Mentioned
    90 Post(s)
    Tagged
    5 Thread(s)

    Default Re: Need HELP with code auto move whole row to new worksheet based on data

    I really don't know why it wouldn't be working now. Can you post a copy of the file that is now not working? Please see Post #6 for instructions.
    Practice makes perfect. I'm very far from perfect so I'm still practising.

  3. #13
    New Member
    Join Date
    Feb 2018
    Posts
    9
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Need HELP with code auto move whole row to new worksheet based on data

    Quote Originally Posted by mumps View Post
    I really don't know why it wouldn't be working now. Can you post a copy of the file that is now not working? Please see Post #6 for instructions.
    Hi thanks for replying again, I think it could be to do with our company server. I need to speak to IT cause it works perfect on my home PC

  4. #14
    Board Regular mumps's Avatar
    Join Date
    Apr 2012
    Location
    Toronto, Canada
    Posts
    8,248
    Post Thanks / Like
    Mentioned
    90 Post(s)
    Tagged
    5 Thread(s)

    Default Re: Need HELP with code auto move whole row to new worksheet based on data

    In order for the macro to work, you have to enable the macros in Excel. Quite often, for security reasons, some organizations will leave them disabled.
    Last edited by mumps; Feb 12th, 2018 at 02:22 PM.
    Practice makes perfect. I'm very far from perfect so I'm still practising.

  5. #15
    New Member
    Join Date
    Feb 2018
    Posts
    9
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Need HELP with code auto move whole row to new worksheet based on data

    Quote Originally Posted by mumps View Post
    In order for the macro to work, you have to enable the macros in Excel. Quite often, for security reasons, some organizations will leave them disabled.
    yes that's what i thought i will check it out tomorrow. i know its not recommended to have macros enabled. thanks again

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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