+ Reply to Thread
Results 1 to 3 of 3

Preserve column comments after pasting new data

  1. 11-02-2020, 02:59 PM #1
    craving77494
    craving77494 is offline
    Registered User
    Join Date
    04-20-2017
    Location
    Katy, Texas
    MS-Off Ver
    2016
    Posts
    6

    Preserve column comments after pasting new data

    I have a worksheet (Issue Management) for managing customer issues. This list can be quite long (~200 records). I have been using column B for users to enter comments on how the issue was corrected (column A is not used). Columns C-Z contain information about the issue. When I export the new issues list from our software, I then copy and paste all of the data into the existing "Issue Management" worksheet. Since issues are resolved in the software, these are often omitted from the new export/list. This of course throws off the comments that were previously entered against a specific issue. I am looking for ideas/suggestions on how I might be able to better manage the list while maintaining comments already associated with previous issues.

    Excel 365
    Windows 10
    Reply With QuoteRegister To Reply
  2. 11-02-2020, 03:51 PM #2
    Bernie Deitrick
    Bernie Deitrick is offline
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 365 (Windows)
    Posts
    5,957

    Re: Preserve column comments after pasting new data

    This assumes that there is a unique identifier in column C of your list.

    Let's say that your list is in the first 200 rows. Place the new list below that, starting in cell C201. In B201, use the formula

    =IFERROR(INDEX($B$1:$B$200,MATCH(C201,$C$1:$C$200,False)),"")

    And copy that down to match your new list. Then copy those formulas and paste values over the same cells, and delete the first 200 rows.
    Bernie Deitrick
    Excel MVP 2000-2010
    Reply With QuoteRegister To Reply
  3. 11-03-2020, 07:05 PM #3
    craving77494
    craving77494 is offline
    Registered User
    Join Date
    04-20-2017
    Location
    Katy, Texas
    MS-Off Ver
    2016
    Posts
    6

    Re: Preserve column comments after pasting new data

    Thank you for the suggestion, it is much appreciated.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Split Comma Separated Column Data into Rows - Preserve Row Data
    By qcjustin in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-11-2018, 07:32 PM
  2. Preserve formatting when pasting part of a cell.
    By Saighead in forum Excel General
    Replies: 4
    Last Post: 06-04-2013, 06:26 AM
  3. [SOLVED] External Data - preserve edited column heading name
    By xltbob in forum Excel General
    Replies: 2
    Last Post: 12-10-2012, 02:22 PM
  4. [SOLVED] Pasting comments
    By Solomon14all in forum Excel General
    Replies: 4
    Last Post: 09-29-2012, 08:16 AM
  5. Using Vlookup when column data changes/preserve old value
    By dta1984 in forum Excel General
    Replies: 1
    Last Post: 11-23-2011, 11:31 AM
  6. HOW DO I PRESERVE FORMATTING WHEN PASTING INTO A NEW WORKBOOK?
    By wamorgan1956 in forum Excel General
    Replies: 4
    Last Post: 04-13-2005, 08:06 AM
  7. [SOLVED] pasting in cell comments
    By John Contact in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-11-2005, 05:06 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1