Create Multiple Worksheets in same Workbook

Closed
varun - Nov 7, 2009 at 01:26 AM
varun3010
Posts
1
Registration date
Friday November 6, 2009
Status
Member
Last seen
November 7, 2009
- Nov 7, 2009 at 01:40 AM
Hello,
I have been looking for a macro in Excel which performs the following task

My workbook presently consists of two worksheet namely Sheet1 and Sheet2. The user types a number in cell A3. Based upon the value entered in cell A3, multiple copies of Sheet2 are automatically inserted in the same workbook.

Thankyou for the help-in advance.

Regards
Varun

2 replies

RiverFox
Posts
8
Registration date
Friday November 6, 2009
Status
Member
Last seen
November 7, 2009
1
Nov 7, 2009 at 01:29 AM
??

I'm confused. The value of A3, in WHICH sheet? Going to where?
0
Hi,

I am sorry I didnt make my question clear.

The user fills in a number in cell A3 in Sheet1. Suppose the user punches the value 3 in cell A3. Then 3 copies of sheet2 should be created in the same worksheet.

Regards
Varun
0
varun3010
Posts
1
Registration date
Friday November 6, 2009
Status
Member
Last seen
November 7, 2009

Nov 7, 2009 at 01:40 AM
Hi,

I am sorry I didnt make my question clear.

The user fills in a number in cell A3 in Sheet1. Suppose the user punches the value 3 in cell A3. Then 3 copies of sheet2 should be created in the same workbook.

Regards
Varun
0