Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Microsoft Visual Basic: Compile error: Sum or Function not defined | Excel Worksheet Functions | |||
Copying Macro w/ different sheets | Excel Worksheet Functions | |||
Macro that stores all sheets as tab-delimited text files | Excel Discussion (Misc queries) | |||
Closing File Error | Excel Discussion (Misc queries) | |||
Macro to link Sheets to main workbook | Excel Discussion (Misc queries) |