+ Reply to Thread
Results 1 to 1 of 1

VBA to Lookup, then Copy and Paste Cell Comments

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

    VBA to Lookup, then Copy and Paste Cell Comments

    Dear Sirs,

    Each month, I’ve to print a report file, say for Apr16 Report, and then check with the previous month Mar16 Report file, and perform the following procedures :
    1. Check Mar16 Report to Apr16 Report for matching Worksheet Name, if found, then
    2. Check column A in Mar16 Report to Apr16 Report for matching Project Number, if found, then
    3. Copy cell comments only in columns F/G/H from Mar16 Report to Apr16 Report (same columns F/G/H)
    4. The process is repeated for all the worksheets in Mar16 Report

    Since this is best to automate by VBA codes, and I would like if anyone could offer assistance, as this seems beyond my capability who know only macro recording at best.
    I also attach sample files for your reference.

    Thank you in advance.

    Edward
    Attached Files Attached Files

+ 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. VBA to lookup matching cell content for copy & pasting cell comments
    By chasoe in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-19-2016, 11:15 PM
  2. [SOLVED] Copy & Paste Cell Contents into Comments in another range of cells
    By Barking_Mad in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-12-2015, 06:38 PM
  3. Replies: 7
    Last Post: 02-04-2014, 06:42 PM
  4. 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
  5. [SOLVED] Copy comments and paste as text
    By Solomon14all in forum Excel General
    Replies: 6
    Last Post: 10-30-2012, 07:39 AM
  6. Copy Cell Comments With Lookup
    By BenRoylance in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-15-2010, 05:06 AM
  7. Copy and paste Comments?
    By proepert in forum Excel General
    Replies: 3
    Last Post: 11-23-2009, 08:01 AM

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