Results 1 to 8 of 8

Copy and paste comment on the adjacent cells

Threaded View

  1. #1
    Registered User
    Join Date
    08-19-2013
    Location
    Hong Kong, China
    MS-Off Ver
    Excel 2013
    Posts
    16

    Copy and paste comment on the adjacent cells

    Hi all gentlemen.

    A sheet, compose of groups of 9 items and their corresponding qty.
    I need to have the same serial no. be commented on each items of the same group.
    I am doing in this mechanical way:
    1. add comment of serial no. on the first item of group,
    2. copy and paste, with paste special>>comments, on the remaining items of the same group,
    3. Repeat this sequences on the other groups, which means hundreds.

    Other than these tedious procedures, is there any better way?

    Many thanks
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Copy and Paste with matching function? Comment Box
    By mdeisen1 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-18-2013, 12:29 PM
  2. [SOLVED] Copy/Paste Adjacent Cells based on ActiveCell
    By brgr4u in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-24-2013, 03:41 PM
  3. Macro: IF given range contains a comment box, then copy cell D1 and paste.
    By azhar.sayed in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-10-2011, 07:22 AM
  4. Copy and paste formula into adjacent cells
    By pixifaery in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-24-2010, 07:25 PM
  5. [SOLVED] copy and paste graphics into comment boxes
    By steve in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-23-2005, 11:05 PM

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