Thread: How do i create upto 50 copies of a spreadsheet within one workboo
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ashish Mathur[_2_] Ashish Mathur[_2_] is offline
external usenet poster
  
Posts: 1,766
Default How do i create upto 50 copies of a spreadsheet within one workboo
Hi,

To work with a non macro approach, go to Insert Worksheet. A new
worksheet will not get created. Now keep pressing F4 till you have 50
sheets.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Paul" wrote in message
...
i have a single spreadsheet which will have various cells such a text,
data.
I want to create up to 50 copies as tabs client1, client2, client3, etc

any ideas
--
Thanks

Paul

Reply With QuoteReply With Quote