Closed Thread
Results 1 to 2 of 2

Copy and paste only unprotected cells...

  1. #1
    Registered User
    Join Date
    01-16-2013
    Location
    Minnesota
    MS-Off Ver
    Excel 2010
    Posts
    15

    Copy and paste only unprotected cells...

    Hi,

    I can't seem to find a simple solution to this problem-

    I need to copy and paste values from employee invoices to a company invoice without affecting the formulas.

    (see examples)

    EMPLOYEE INVOICE EXAMPLE.xlsxCOMPANY INVOICE EXAMPLE.xlsx

    I need to copy and paste only the quantity values and not the dollar amounts.

    I've tried protecting the sheet and locking the cells that I don't want the formulas from. I've tried pasting values and paste special.
    I know I could hold CTRL or rewrite the formulas in the company invoice after pasting, but is there not an easier way?

    Thanks for any help you can provide!

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,610

    Re: Copy and paste only unprotected cells...

    Welcome to the Forum, unfortunately:

    This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

    Thread Closed.
    Ben Van Johnson

Closed Thread

Thread Information

Users Browsing this Thread

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

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