In "order sheet" cell (E8) (in fact is a order fomr), i have to enter a number and that number would create the number of new sheets with data from other sheet(Label).
Eg. if i enter a 4 on (E8), 4 new label worksheets are being created.
how do i do it? Need some urgent help here.. thanks Book1.xls
Last edited by leungnash; 07-18-2013 at 12:24 AM.
Hi and welcome to the forum
THis cannot be done with regular formulas/functions, you need VBA to do this...I will move your question to the VBA forum
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
duplicate post (mine)
Last edited by FDibbins; 07-18-2013 at 12:19 AM.
can anyone help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks