template that automatically removes certain columns when pasted in
 

Hi Can anyone help with the following: I need two templates (or to create
them)
that will do the following:
1.it will automatically hide
2.it will automatically remove ... pre selected columns every time that they
are pasted in .

1.When I paste columns into a new worksheet i need one worksheet to
automatically
hide certain columns.
2. When I paste columns into a new worksheet I need one worksheet to
automatically delete certain columns

Many Thanks