VBA Loop through each worksheet except two and then copy paste

Hi All,

I am facing issue. I do have macro which populates sheets based on given list.

I want to paste all data in newly created sheets from “Template”.

I do not want to loop 2 sheets (“DATA” & “Template”).

Data must be pasted with format & validation. Validation exists on Template sheet only. No other sheet is referred for validation.

Please help me. I am stuck.

Hi akulka58,

Try the following macro, which copies the template, instead of adding new sheets.

Please Login or Register  to view this content.

Lewis

Hi Lewis,

Thanks it works perfect