+ Reply to Thread
Results 1 to 2 of 2

Macro regarding copy cut paste drag

  1. #1
    Registered User
    Join Date
    06-15-2012
    Location
    Springfield, MO
    MS-Off Ver
    Excel 2007
    Posts
    2

    Macro regarding copy cut paste drag

    I won't go into the details of why I need this, but it is very important because all of the users at work are screwing the spreadsheet up no matter how much i try to protect it.

    There is only one sheet that data is entered. They need to be allowed to move data from cell to cell, without changing formats and formulas.

    Basically. I want them to be able to "copy and paste" and "drag and fill" ONLY. When they do, I want them to move "values" ONLY.

    I have tried to teach them how to paste special, but they keep screwing up the sheets, and I want to make it mistake proof.

    I am very well versed in excel, but I just have a little bit of surface knowledge in VBA. Is there some code that can do this for me?

    Thank you. This is my first post.

  2. #2
    Registered User
    Join Date
    06-15-2012
    Location
    Springfield, MO
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Macro regarding copy cut paste drag

    My heading said macro regarding copy cut pste drag. I meant to say code instead of macro. Once again, surface knowledge.

+ 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