Macro for adding more sheets
 

Hi,

I am creating a workbook that needs to be able to generate additional sheets
when needed. For example, I have one page (Top Page) that lists the total
cost of timber from different suppliers plus who those suppliers are. Each
supplier has it's own sub-page where the materials they have supplied is
totalled up. At present, the Top Page has five rows that allow people to
enter the company name, address and total cost. If someone wanted to use
the workbook to add a sixth supplier, I would like for them to be able to
click on a button marked "Add Supplier". This should then add an extra row
and automatically link it to a newly created page that will be formatted
using the same template as the pages for the other five companies. How do I
set up the macro that will do this? i tried to figure this out but could
not. Thank you.

Macro for adding more sheets
 

http://www.mvps.org/dmcritchie/excel/sheets.htm

this site has a worksheet change code that adds a sheet when column f
changes


this site has code for adding rows
http://www.mvps.org/dmcritchie/excel/insrtrow.htm

heres a code that checks the selected range, if there is a sheet name
in the selected range..well I will attatch the post and you can see
what it does
http://forums.techguy.org/business-a...l-content.html


--
davesexcel


------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=537521