View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] azu_daioh@yahoo.com is offline
external usenet poster
 
Posts: 28
Default copy worksheet multiple times base on user's input

Im hoping someone could show me how to code this. How do I copy a
worksheet x number of times? The user will have to enter then number
in a cell and upon cell selection change, I want Excel to
automatically copy the worksheet.

Sheet1 = has cell "howMany" (where user would enter the number of
worksheets needed)
Sheet2 = is the worksheet to be copied multiple times


Thanks a bunch


Sharon