Worksheet that automatically hides removes certain column pasted i
 

Hi Can anyone help with the following: I need two templates (or to create
them)
that will do the following:
1. To automatically hide
2.The other to 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