Copying Mastersheet layout to the rest of the sheets

T

TooN

Hi...

Ive got a small problem but it takes me a lot of time to fix it all the
time. Ive got a mastersheet (sheet1) with a lot of data. Im using a macro to
filter it and than automaticly copy the filtered data to another worksheet
(http://www.contextures.com/excelfiles.html#Filter FL0013). Works perfect but
there is a small problem. In the mastersheet i adjusted the column with, ive
added a few additional formatting to it and a few formulas. When i use the
macro to filter and copy the filtered data to another worksheet it doesnt
copy the layout.

Is there a macro to copy the layout and settings (like columnwidth,
additional formating, formulas) to other sheets in the same workbook. All the
cells are basicly on the same position as on the mastersheet!!

Thanks in advance and i hope someone can help me cause its killing me....

TooN
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top