Search : in
By :

Create Multiple Worksheets in same Workbook

Last answer on Nov 7, 2009 6:40:03 am GMT varun, on Nov 7, 2009 6:26:53 am GMT 
 Report this message to moderators

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

Configuration: Windows Vista
Safari 532.0

Best answers for « Create Multiple Worksheets in same Workbook » in :
Excel – Macro for copy & paste selected range ShowExcel – Macro for copy & paste selected range Issue Solution Note Issue I have a summary of data by month in one sheet and the raw data in another sheet. Instead of creating multiple worksheets for my raw data for each month, I want...
Assembling multiple PDF files ShowAssembling multiple PDF files Intro Steps: Intro PDF creator is a software allowing you to print several files into one with its printer function. Download link http://en.kioskea.net/telecharger/telecharger-40-pdf...
Software for creating video game (RPG maker, Mugen, etc.). ShowSoftware for creating video game (RPG maker, Mugen, etc.) Software for creating versatile games Software to create fighting games Software for role play games Other software If you have no programming skills, but you want to create...
Download Multiple Database Query Analyzer Show
Download PDF Creator ShowSupports Windows 7 Beta PDFCreator is a free tool to create PDF files from almost any application that can print. It also possesses options of security allowing to code the PDF to protect their reading. PDF Creator also allows to create images...
Download The Logo Creator ShowDescription The logo creator was designed by Laughingbird Software Groups. The application is based on the creation of logos. Also, the application is available for everyone; no knowledge requirements needed to use it. Logo Creator is simple and...
Creating a local area network ShowWhy set up a local area network? When you have several computers, it can be convenient to connect them to each other to create a local area network (LAN). Setting up such a network costs very little, contrary to what people may think. Here are a...
Creating a LAN ShowWhy set up a LAN? If you have several computers, it may be worthwhile to connect them in order to create a local area network (LAN). Setting up such a network is much less expensive than what you might think. Here are a few ways you might benefit...
Data transmission - Multiplexing ShowIntroduction to multiplexing Multiplexing refers to the ability to transmit data coming from several pairs of equipment (transmitters and receivers) called low-speed channels on a single physical medium (called the high-speed channel). A...
Ask your question Reply

1

RiverFox, on Nov 7, 2009 6:29:06 am GMT

??

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

   
Reply to RiverFox

2

varun, on Nov 7, 2009 6:37:30 am GMT

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

   
Reply to varun

3

 varun3010, on Nov 7, 2009 6:40:03 am GMT

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

   
Reply to varun3010
Ask your question Reply
They need your help