+ Reply to Thread
Results 1 to 3 of 3

copy and paste without overwriting cells containing values

  1. #1
    Registered User
    Join Date
    07-30-2008
    Location
    UK
    Posts
    52

    copy and paste without overwriting cells containing values

    please see attached pic,

    ive got a formula in a cell, which i want to copy and paste onto cells below it, without overwriting values in cells already there.

    is there any way to do this?

    thanks
    Attached Images Attached Images

  2. #2
    Registered User
    Join Date
    08-13-2008
    Location
    London, UK
    Posts
    8
    If I understand correctly you want to populate empty cells with the formula?

    If you select a range of cells and use Go to by pressing F5, you can press the Specials button, then select "Blanks" to select the blank cells and you could then paste in a calculation possibly.

    Laura

  3. #3
    Registered User
    Join Date
    07-30-2008
    Location
    UK
    Posts
    52
    thanks for your response.

    that sort of worked, but unfortunately it doesn't consider cells containing '0.00' as blank cells. Maybe i could insert a formula first that says 'IF cell has value greater than 0.00, leave as cell value, otherwise change to BLANK', then i'd be able to copy and paste the formula using your system and not overwrite anything.

    any idea how to make this formula?

+ 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