+ Reply to Thread
Results 1 to 2 of 2

Macro to copy specific color cells frm multiple sheets & paste link to other similar wrkbk

  1. #1
    Registered User
    Join Date
    02-04-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    2

    Macro to copy specific color cells frm multiple sheets & paste link to other similar wrkbk

    Hi,
    I am just new to this forum...looking to learn VBA & macros from experts. To begin with I need urgent help from VBA champions, what I am looking for is :

    I have a template which has its sheets protected & also has some macros which are also password protected, Let me Call this "Template". In this workbook there are multiple sheets with a unique color code "Orange" which are basically the input cells. This file since has lot of protection the maneuvering is difficult. So to cut short the time taken to fill the input cells in each sheet, I moved all the sheets to another workbook, lets say workbook with the name "Template Feedback", which is password free & is easy to use. Now this workbook i.e. "Template Feedback" is exactly similar to the main file. What I am looking for is a macro or VBA code which can be used in workbook "Template Feedback" so that I can paste link all the unique color cell range of the main file i.e. "Template" file with this new workbook i.e. "Template Feedback".
    I only want to link the orange color cells of file "template" with Template Feedback" & the macro needs to be done in file "template feedback" as the other one is protected. Also I cannot paste a an entire range in "template' file as it does not allow to paste it on cell ranges. So only orange color cells needs to be linked through macro with the same range.

    Please help.

  2. #2
    Registered User
    Join Date
    02-04-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Macro to copy specific color cells frm multiple sheets & paste link to other similar w

    somebody please help...

+ 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