#1
|
|||
|
|||
How do i reference a cell color from another workbook? Vba code help
I have created a workbook (call it "FINAL") where each sheet references sheets from other workbooks (I did this by making a copy of the original sheet over to "FINAL" to get the proper layout, then used the simple formula of typing = in "FINAL" then dragging over the data in the original sheet). This makes it so whenever edits are made in the original sheets, it updates "FINAL". However, I cannot get "FINAL" to mimic color fills.
How do I get Sheet 1 in my "FINAL" workbook to change the fill in its referenced cells whenever the original workbook fills a cell with color? I believe I need VBA code, but I only know how to use this within the same workbook. |
Tags |
fill, reference, vba |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Cell text color vs cell background color | AC PORTA VIA | Excel Programming | 4 | 12-19-2018 04:01 PM |
Macro to change an RGB table cell shading color to another RGB color | David Matthews | Word VBA | 4 | 05-29-2018 02:45 PM |
vba code for integrating particular information from different workbook to one workbook | klpw | Excel Programming | 1 | 12-28-2015 09:48 AM |
Reference another workbook and return values from the same cell across multiple sheets/tabs | lwls | Excel Programming | 5 | 11-08-2014 02:11 PM |
Assign the value of a cell as a cell reference of another cell in Excel 2010 - How to? | bharathkumarst | Excel | 7 | 10-13-2014 10:25 AM |