I am trying to write a macro to copy data from one sheet to individual
worksheets

The data is stock prices

Each stock has 2 columns worth: Date and Price

I wish to:
Copy the template tab to create a duplicate worksheet
copy column A and column B data
Paste into column A and B of the new duplicate worksheet
Name the worksheet with the data in Row1

and then do the same for the next set of data - in Column D and E

and then again for the next data in G and H

...etc potentially around 600 stocks

sample data attached



many thanks
Rob


+-------------------------------------------------------------------+
|Filename: sample data.xls |
|Download: http://www.thecodecage.com/forumz/attachment.php?attachmentid=110|
+-------------------------------------------------------------------+

--
gwatcheater
------------------------------------------------------------------------
gwatcheater's Profile: http://www.thecodecage.com/forumz/member.php?userid=235
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=86422