Copy sheet data to all other existing sheets except two.

[ANDREAAS]

Hi All

I have a workbook with about 50 sheets. Among them are a sheet called "Names" and a sheet called "Master".

I need a VBA to copy the contents of "Master" to all the other sheets in the workbook except "Names" and "Master".

Any help would be much appreciated,

Thanks in advance.

[Fluff13]

Do you want to clear the other sheets before copying the data?

[ANDREAAS]

No, there is no need. The other sheets are created by a macro that creates and names them all from the "Names" sheet, so they wil all be new sheets and clear of any data.

[Fluff13]

In that case, how about

Please Login or Register  to view this content.

[ANDREAAS]

Thank you Fluff. Works a charm. You RocK!!!!

[ANDREAAS]

Is there a way to maintain the column spacing when copying like this?

[Fluff13]

How about

Please Login or Register  to view this content.

[ANDREAAS]

Thank you Fluff

[Fluff13]

You're welcome & thanks for the feedback