One more thing i have noticed that macro delete the complete Column contains "NA" value from the sheet but as i have mentioned on my prev mail that i want the specific cloumns based on Process name becasue sometime it happens that in required columns we have to enter "NA" so in that case macro will del that column which is not reqired
Once again i am provide you the same info for your ref kindly give the below condition to maco to be saved in output folder Prcoess Name - Test columns wanted in diff sheets are Process 1- Test1 & 2 Process 2-Test 3,4,5 Process 3-Test 1&3,5 Process 4-Test1 & 2 Process 5 -Test1, 2,3 I just want that above columns(whatever the value in that) to be saved with other details except " sheet Name should Be" column in outout folder . Thanks in advance. On Sun, Feb 20, 2011 at 12:13 PM, maulik desai <mauliksde...@gmail.com>wrote: > Hi Mahesh, > > Thanks for the lovely Solution but 2 minor modification i wanted from you > > 1. File should be saved in Excel 2003 format (.xls) ,Currently it is saved > in .xlsx format > 2. i dont want " sheet Name should Be" Column should be saved on output > sheets because it is just for your information,kindly removed that column > from each sheet rest is perfect. > > Request you to kindly modify this 2 changes and pls send it updated one > > Thanks & appricated your time & kindness. > > > On Sat, Feb 19, 2011 at 8:00 PM, Mahesh parab <mahes...@gmail.com> wrote: > >> Hi Maulik >> >> i have tested pervious files, its working correctly. only i done changes >> to remove NA in existing one. >> for C-Test as per u its 1&3 it should be 1,3,5 as per data >> hope its as per u r requirement, i herewith attach revised workbook as >> well steps in word file since u r getting below error >> >> >> On Fri, Feb 18, 2011 at 1:02 AM, maulik desai <mauliksde...@gmail.com>wrote: >> >>> Thanks mahesh, >>> >>> there is some problem with the code >>> >>> when i click on Create workbook button it give me error in code >>> >>> ActiveWorkbook.SaveAs (sPath & sFileName) >>> >>> also border part also not execute >>> >>> request u to kindly check the same >>> >>> And my earlier mail have mentioned that each process has is own tests so >>> i just want that after extracting data to diff sheets i just want the test >>> columns according to that process only >>> >>> In this exp >>> Emp name - Test columns wanted in diff sheets are >>> A- Test1 & 2 >>> V-Test 3,4,5 >>> C-Test 1&3 >>> D-Test1 & 2 >>> E-Test1, 2,3 >>> >>> In short i dont want test scores with NA just want pass columns >>> >>> Hope u understand..... >>> >>> On Wed, Feb 16, 2011 at 12:58 PM, Mahesh parab <mahes...@gmail.com>wrote: >>> >>>> Hi Maulik >>>> >>>> find attach, prepared as per my understanding >>>> 1. it will create separate worksheet for each value in column J (emp >>>> name & date) >>>> 2. it will crate separate workbook for each value in column J, create a >>>> folder name Output in thisworkbooks path (where u save the file) >>>> for each new workbook it will border the used cells >>>> >>>> >>>> >>>> On Wed, Feb 16, 2011 at 2:14 AM, maulik desai >>>> <mauliksde...@gmail.com>wrote: >>>> >>>>> Hi Gurus, >>>>> >>>>> I Just want to create Diff excel sheet based onn Emp name & sheet name >>>>> should be "emp name & date".there are diff test are available for each >>>>> process I also want to update that process test scores in respective sheet >>>>> (kindly see the sheets for more info),i am having very large excel >>>>> database >>>>> & every week process names are changed so request you to kindly proive the >>>>> solution which creates the automatically sheet name & filter the test >>>>> columns & also i want to create that sheet as a individual workbook & need >>>>> to saved automatically on desktop with same sheet name & date. >>>>> >>>>> -- >>>>> Thanks & Regards, >>>>> Maulik Desai >>>>> 9967363926 >>>>> >>>>> -- >>>>> >>>>> ---------------------------------------------------------------------------------- >>>>> Some important links for excel users: >>>>> 1. Follow us on TWITTER for tips tricks and links : >>>>> http://twitter.com/exceldailytip >>>>> 2. Join our LinkedIN group @ >>>>> http://www.linkedin.com/groups?gid=1871310 >>>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com >>>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >>>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >>>>> >>>>> To post to this group, send email to excel-macros@googlegroups.com >>>>> >>>>> <><><><><><><><><><><><><><><><><><><><><><> >>>>> Like our page on facebook , Just follow below link >>>>> http://www.facebook.com/discussexcel >>>>> >>>> >>>> -- >>>> >>>> ---------------------------------------------------------------------------------- >>>> Some important links for excel users: >>>> 1. Follow us on TWITTER for tips tricks and links : >>>> http://twitter.com/exceldailytip >>>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com >>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >>>> >>>> To post to this group, send email to excel-macros@googlegroups.com >>>> >>>> <><><><><><><><><><><><><><><><><><><><><><> >>>> Like our page on facebook , Just follow below link >>>> http://www.facebook.com/discussexcel >>>> >>> >>> >>> >>> -- >>> Thanks & Regards, >>> Maulik Desai >>> 9967363926 >>> >>> -- >>> >>> ---------------------------------------------------------------------------------- >>> Some important links for excel users: >>> 1. Follow us on TWITTER for tips tricks and links : >>> http://twitter.com/exceldailytip >>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >>> 3. Excel tutorials at http://www.excel-macros.blogspot.com >>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >>> >>> To post to this group, send email to excel-macros@googlegroups.com >>> >>> <><><><><><><><><><><><><><><><><><><><><><> >>> Like our page on facebook , Just follow below link >>> http://www.facebook.com/discussexcel >>> >> >> > > > -- > Thanks & Regards, > Maulik Desai > 9967363926 > -- Thanks & Regards, Maulik Desai 9967363926 -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
