+ Reply to Thread
Results 1 to 7 of 7

Copy and paste values if cell to the left is filled

  1. #1
    Registered User
    Join Date
    01-14-2013
    Location
    Jupiter
    MS-Off Ver
    Excel 2013
    Posts
    78

    Copy and paste values if cell to the left is filled

    See workbook for further explanation.
    Attached Files Attached Files

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,897

    Re: Copy and paste values if cell to the left is filled

    Where do the values need to be pasted to? And only for the rows having a value in column BI? All other rows are ignored? Is this correct?

    Assuming my understanding is correct above and pasting values to Column CN.

    Please Login or Register  to view this content.
    Last edited by alansidman; 06-04-2013 at 06:29 PM.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Registered User
    Join Date
    01-14-2013
    Location
    Jupiter
    MS-Off Ver
    Excel 2013
    Posts
    78

    Re: Copy and paste values if cell to the left is filled

    The values need to be pasted into columns CR.

  4. #4
    Registered User
    Join Date
    01-14-2013
    Location
    Jupiter
    MS-Off Ver
    Excel 2013
    Posts
    78

    Re: Copy and paste values if cell to the left is filled

    In my workbook the values that need copied are also in CR. I just want to get rid of the formulas. So I want to copy the values and paste them back into their original cell.

  5. #5
    Registered User
    Join Date
    01-14-2013
    Location
    Jupiter
    MS-Off Ver
    Excel 2013
    Posts
    78

    Re: Copy and paste values if cell to the left is filled

    Here's my workbook, if you need to see it.
    Attached Files Attached Files

  6. #6
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,897

    Re: Copy and paste values if cell to the left is filled

    Change my code to:
    Please Login or Register  to view this content.

  7. #7
    Registered User
    Join Date
    01-14-2013
    Location
    Jupiter
    MS-Off Ver
    Excel 2013
    Posts
    78

    Re: Copy and paste values if cell to the left is filled

    Just what I needed, thanks!

+ 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