+ Reply to Thread
Results 1 to 2 of 2

VBA to lookup matching cell content for copy & pasting cell comments

  1. #1
    Forum Contributor
    Join Date
    03-27-2015
    Location
    Hong Kong
    MS-Off Ver
    Excel 2010
    Posts
    141

    VBA to lookup matching cell content for copy & pasting cell comments

    Dear Sirs,

    I've a monthly routine to print out a report for a month, say Apr16, and is required to make reference to Mar16 report to do the following boring copy and pasting :

    1. Check matching worksheet name in Mar16 Report with Apr16 Report, if found, then
    2. Check matching project number in column A, if found, then
    3. Copy cell comments (annotations) only from Mar16 Report for 3 columns F, G and H to Apr16 Report (to same columns F, G and H)

    The work procedure is simple but repetitive, and best to automate by VBA codes.

    I enclose the 2 sample files for your reference.

    Would be grateful is someone could help.

    Thx so much.
    Attached Files Attached Files
    Last edited by chasoe; 05-19-2016 at 11:08 PM.

  2. #2
    Forum Contributor
    Join Date
    03-27-2015
    Location
    Hong Kong
    MS-Off Ver
    Excel 2010
    Posts
    141

    Re: VBA to lookup matching cell content for copy & pasting cell comments

    Sorry, this thread was duplicated and should be removed, as a new one already posted.
    Thx

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] How to dynamically convert cell content from one sheet to comments in another?
    By clairejasper in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-18-2016, 01:26 AM
  2. copy cell text to comments in excel 2010 and vise versa (i.e. from comments to cell)
    By senthile in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 01-25-2014, 12:16 PM
  3. Replies: 2
    Last Post: 07-31-2012, 03:42 PM
  4. Replies: 8
    Last Post: 03-26-2011, 04:53 AM
  5. Copy Cell Comments With Lookup
    By BenRoylance in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-15-2010, 05:06 AM
  6. [SOLVED] How do I export comments into another excel column as cell content
    By Hernan in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-25-2005, 11: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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1