climbingchillie
New Member
- Joined
- May 22, 2018
- Messages
- 1
Hi
I'm a complete newbie to VBA and struggling to find a google answer that fits my specific needs and lack of knowledge.
I have 2 workbooks; One called 'Master' that contains a unique code in column A and a long text description with bold, coloured text and colour shading (not conditional, specific to each individual cell) in column B
The second workbook, "Audit", has the unique references in column B and i'd like to run the formula/return the result in column D.
Based on the unique reference in column A of "Master" matching column B in Audit i'd like to return the values of column B in Master including all formatting to column D in Audit.
Any help is greatly appreciated!
Master Example
<tbody>
</tbody>
Audit example
<tbody>
</tbody>
I'm a complete newbie to VBA and struggling to find a google answer that fits my specific needs and lack of knowledge.
I have 2 workbooks; One called 'Master' that contains a unique code in column A and a long text description with bold, coloured text and colour shading (not conditional, specific to each individual cell) in column B
The second workbook, "Audit", has the unique references in column B and i'd like to run the formula/return the result in column D.
Based on the unique reference in column A of "Master" matching column B in Audit i'd like to return the values of column B in Master including all formatting to column D in Audit.
Any help is greatly appreciated!
Master Example
A | B |
GLA 2015/11 | Does the client drive goods vehicles over 3.5 tonnes in London? If so, are they fitted with: (i) a class V mirror on the passenger side (ii) a class VI mirror to the front of the vehicle and (iii) sideguard |
<tbody>
</tbody>
Audit example
B | C | D | |
Reference | Title | Audit Questions | |
GLA 2015/11 |
<tbody> </tbody> | FORMATTED RESULT HERE | |
<tbody>
</tbody>