Macro to copy and paste

[Neil Holden]

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?

 

[Don Guillett]

First we need to understand your terms.
An excel sheet is a worksheet within a workbook(file). Now detail exactly
what you need.