Hi Maulik do u want to delete column which contain only "NA" , not "Na" is both are different or same
On Mon, Feb 21, 2011 at 12:08 PM, maulik desai <mauliksde...@gmail.com>wrote: > 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
