Copying only report sheets
 

Hi: Happy new year. I created a MS excel workbook which has 4 data
sheets and 4 report sheets. Each report sheet links to each data sheet.
Now I want to create another workbook that will show only the 4 report
sheets. How can I do it in VB code? Agin, in each report sheet, I copy
and paste data from data sheet and thus each report points to
individual data sheet.

Workbookname: ctces
sheet names:dat1,rep1,dat2,rep2,dat3,rep3,dat4,rep4

Best wishes and thanks


--
jesmin
------------------------------------------------------------------------
jesmin's Profile: http://www.excelforum.com/member.php...o&userid=29540
View this thread: http://www.excelforum.com/showthread...hreadid=501742