Excel 2003 linking text format in two workbooks

15 pts.
Tags:
Excel workbooks
Linking workbooks
Microsoft Excel 2003
Microsoft Excel formulas
I have 8 different workbooks that are linked to one master workbook. In each of the 8 workbooks people need to select certain names and change the text format to bold. however when the master workbook is open and updated the BOLD format is not there. Each of the 8 workbooks are changed monthly with old names changed from bold to regular text and new names put in bold. How can I carry this text formatting from the 8 workbooks to the master workbook?

Answer Wiki

Thanks. We'll let you know when a new response is added.

You will probably need to write a VBA macro that does this. Formatting is not pushed down from the workbook that the user opened to the workbook that holds the source data.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following