Macro to copy and paste
 

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?

Macro to copy and paste
 

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Neil Holden" wrote in message
...
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?