View Single Post
  #1   Report Post  
daolb
 
Posts: n/a
Default macro/new sheets


my excisting workbook exists out of 4 sheets, one general sheet, and 3
detail information sheets. I want the possibility to create in one
actions duplicates of those 3 sheets, so i get 7 sheets. I may redo
that several times.

I though about macro's to do that. I also want that the name of the
sheet is created automatically, this by adding by the sequence number
+1.

for example

global
use_scrn001
fun_scrn001
stat_scrn001

ACTION COPY

global
use_scrn001
use_scrn002
fun_scrn001
fun_scrn002
stat_scrn001
stat_scrn002


--
daolb
------------------------------------------------------------------------
daolb's Profile: http://www.excelforum.com/member.php...o&userid=24478
View this thread: http://www.excelforum.com/showthread...hreadid=381921