+ Reply to Thread
Results 1 to 4 of 4

Excel 2003 How can I shift values from adjacent cells over to an adjacent column

  1. #1
    Registered User
    Join Date
    06-22-2012
    Location
    New Brunswick, NJ
    MS-Off Ver
    Excel 2003
    Posts
    53

    Excel 2003 How can I shift values from adjacent cells over to an adjacent column

    I have 3 columns. First is months listed 2012-01 to 2012-06 (repeated). The 2nd has a number of notes for each month. The 3rd has the number of notes for the new month June. How can I move values from the June column over to the 2nd column so my report is up to date. I attached a sheet below to help see the problem. Thank you very much in advance!
    Attached Files Attached Files

  2. #2
    Forum Guru Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: Excel 2003 How can I shift values from adjacent cells over to an adjacent column

    In column D, how about..

    =IF(A2="2012-06",C2,B2)

    then copy and paste sepcial values in Column B
    Life's a spreadsheet, Excel!
    Say thanks, Click *

  3. #3
    Registered User
    Join Date
    06-22-2012
    Location
    New Brunswick, NJ
    MS-Off Ver
    Excel 2003
    Posts
    53

    Re: Excel 2003 How can I shift values from adjacent cells over to an adjacent column

    The values that are already in column B for the other monthsare correct so I dont want to copy and paste over them, I only would want to copy the values in column C that correspond to the month of June. Is there a way I can do this also?

  4. #4
    Valued Forum Contributor Melvinrobb's Avatar
    Join Date
    06-19-2012
    Location
    Manitoba, Canada
    MS-Off Ver
    Excel 2013
    Posts
    1,128

    Re: Excel 2003 How can I shift values from adjacent cells over to an adjacent column

    Paste this formula in Column D:
    =IF(AND(B2="",C2=""),"",IF(B2="",C2,B2))

    I originally thought you could "paste special - values, skip blanks", but excel considered the blank cells in column c to be "0" for some reason.

    ---------- Post added at 10:20 AM ---------- Previous post was at 10:09 AM ----------

    I just realized the formula I suggested is not working.
    Paste the formula suggested by Ace in column D.
    then in column B paste the following formula:
    =IF(D2="","",D2)
    This should give you an updated list.

    NOTE: You will need to highlight column D and "paste special - values" first!
    Last edited by Melvinrobb; 07-30-2012 at 11:22 AM. Reason: Missing instructions

+ 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