View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Lori Lori is offline
external usenet poster
 
Posts: 340
Default DUPLICATE 1 sheet into 100 sheet workbook

Try This:

1. Hold down Shift+F11 until you get 100 worksheets.
2. Right click the original sheet and choose Select All Sheets
3. Choose Edit Fill Across Worksheets and then click All followed
by OK.