Hi mahesh, in a simple manner u have given instruction to macro to del column which contains "na" value in any columns right but i want that instead of specific value bifercation i want that entire column should be their rest columns to be deleted
for eg. If if u select process 5 or emp name e i only want test1,test2 and test3 columns nad rest 2 columns need to del. And so on... I just want that macro should give me output based on columns specification and not based on specific value i hope i have given proper explanation pls revert with solution On 2/20/11, Mahesh parab <mahes...@gmail.com> wrote: > Hi Maulik > > find attach, for test columns u r using Pass or NA values if u want to > retain specific column use another value or string other then "NA" > i didnt get " i want the specific cloumns based on Process name becasue > sometime it happens that in required columns " > as far as New workboooks in output folder are concern reflecting same > columns as mention by u > > On Sun, Feb 20, 2011 at 12:27 PM, maulik desai > <mauliksde...@gmail.com>wrote: > >> 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 >> > -- Sent from my mobile device 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
