Custom button :Copy data to new workbook
 

I'd like to create a button in a worksheet "1".

With a click of this button, values/data in selected cells from thi
MASTER workbook can be copied into certain cells in a new workbook(fro
a template).

Then when I save this new workbook, the file name will contain som
reference number froom the MASTER and also the date.

Can anyone please help?

H

--
hoswee
-----------------------------------------------------------------------
hosweec's Profile: http://www.excelforum.com/member.php...fo&userid=3535
View this thread: http://www.excelforum.com/showthread.php?threadid=55125