Formulas cannot bring over formatting.

You must also copy the formatting when you make a new sheet.

Perhaps a template of the sheet with formatting applied would do the trick.

Open a new workbook and delete all but one sheet.

Do your formatting and FileSave asFile typeTemplate(*.xlt)

Name it SHEET and save it to your XLSTART folder.

This will be the InsertInsert Worksheet


Gord Dibben MS Excel MVP

On Thu, 19 Jan 2006 16:46:26 -0600, aaalissha
wrote:


Hi,

Thanks for your response, I can do that, but the original file is
updated atleast few times a week. So it will be a tedious job to do.
Right now what I am doing is just copying the columns I want, e.g.
file2!A1=file1!B1 something like it,but it doesn't bring over the
formulas, I create file2 only once and whenever there is a change in
file1, I just use replace all in file2 to replace the file1 in the
formulas by the new file name. so it will automatically change the
values. Is there a way to bring over the background color?

Thanks.