Hello everyone! :)

I'm an excel newbie and i need your help with something.
I have a project where i created a workspace with several sheets in it.
I use the 1st sheet as a template to enter all information and the data is
spread to the other sheets using the obvious command: =Template![A-Z][#].

My problem starts with the "Wrap Text" option, for some reason it refuse to
resize the destination cell when new data is entered.

I've read several comments here that said that "Merged" cells have a problem
with "auto fit" and seen some VB code posted as well, but i have no idea how
to use it (again, newbie here.. :) )

Can someone help me out and instruct me where exactly do i enter the VB code
for it to work?
Will the VB make the "auto fit" run automatically? or do i need to use some
kind of key combinations to activate it?

Thanks in advance for all the helpers! :)