linking

[NewExcelUser]

When linking to other workbooks using the equal "=" sign, how can I make sure the format will follow so that my master workbook will look like the other workbooks?

Or is there a better way?

 

[nevillestoke]

Do you mean you want the format of the source file to be carried into the destination file? If so, the only way I know to do this is to copy the source range and paste special | formats into the destination file.

Someone on the forum may have VBA code to do this automatically, but I don't think it can be added to the function - unless you are speaking of numeric formatting, which I can help you with.

Let us know.