kdel50
Oct 1, 2012, 11:45 AM
I will use the example of an Excel Workbook that has 3 Worksheets linked together.
Worksheet 1 is like a base that supplies the info to be linked to Worksheet 2. Worksheet 1 has cells that are merged, text colors other than black, boarders, specific column widths and row heights.
Is there any way for all the above mentioned formats in linked cells to carry into Worksheet 2?
I'm familiar with Paste Special but have not had luck with this. The linking disappears.
Worksheet 1 is like a base that supplies the info to be linked to Worksheet 2. Worksheet 1 has cells that are merged, text colors other than black, boarders, specific column widths and row heights.
Is there any way for all the above mentioned formats in linked cells to carry into Worksheet 2?
I'm familiar with Paste Special but have not had luck with this. The linking disappears.