i have a sheet."mysheet"..when ever i enter a value in the "qty" column,a new sheet(we can call "mynewsheet") should be generated automatically including some text and table(like template) and copy some fields corresponding to "qty" column in "mysheet" to "mynewsheet"
This is doable. But can you attach a sample workbook so that we can provide you a faster solution?
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
For example:sheet1.xlsOriginally Posted by arlu1201
Item_discription Qty
Machinery 1
when ever a value is entered in the field of "Qty" here...there should be generated a new sheet with a name(call "mysheet'')..and the value of filed such as item_discription ,"Qty",corresponds to this "Qty" in sheet1.xls should be copied to newly generated mysheet.xls...this mysheets must be in the form of a template(ie:...contains some heading " welcome" and some qty column and item_description)
Did you attach the sample workbook (as i dont see it here)? It will be easier to understand if you provide a before and after sheet.
can you help me to copy some fields from one sheet to another and save the form..?
As per whatever limited information you have provided, i have the code as below :
But this is in a crude form right now since we do not have the complete requirements nor the sample workbook. The code will allow you to only create one sheet titled "mynewsheet". If you need more sheets to be created, we have to edit it some more.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks