Hi all Excel Gurus,

I need help. I have an excel sheet call template and i want to create a
button to copy a selection of data which is B9:B34 and i need it to paste the
information to another excel sheet called data which will be A:AA and add
each row when pressed. When the data has been copied over i need it to close
the data sheet.

Can someone help me please?