HI Mahesh Sir, Thanks for the such a nice code but it is just 2nd portion of the code i think you have not add the 1 part which we have discussed at afternoon and onemore thing that i have given u the process base test columns to be deleted after the filter which we have discussed alreay
Request you to kindly add this two things inz macros & resend it Thanks you very much for your time and Support On Thu, Feb 24, 2011 at 10:46 PM, Mahesh parab <mahes...@gmail.com> wrote: > Hi Maulik > > find attach, hope this is done. > > On Mon, Feb 21, 2011 at 11:01 PM, maulik desai > <mauliksde...@gmail.com>wrote: > >> Hi mahesh, >> >> both r the same >> as i have mentioned on my prev mail dont look any value just want to >> delete complete column based on process name and the eg will remain >> same (pls refer earlier mail). Still if u want we can communicate via >> phone. If u can give me ur cell no or if u want u can also call me. >> >> On 2/21/11, Mahesh parab <mahes...@gmail.com> wrote: >> > 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 >> >> >> > >> >> -- >> Sent from my mobile device >> >> 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
