Re: $$Excel-Macros$$ Advance filter issue

2013-04-14 Thread Rajasekhar Praharaju
hi Experts, Need your help , as i could not club both sheets in new workbook. Thanks, Raj On Sun, Apr 14, 2013 at 12:02 PM, Rajasekhar Praharaju rajasekhar.prahar...@gmail.com wrote: Hi friends, Please assist with Advance filter issue, i have created a macro which will be taking unique

Re: $$Excel-Macros$$ Advance filter issue

2013-04-14 Thread pavithra murthy
Hello, I tried writing a macro code. Will give you the result shortly Thanks, Pavithra --- On Sun, Apr 14, 2013 at 3:58 AM, Rajasekhar Praharaju rajasekhar.prahar...@gmail.com

$$Excel-Macros$$ print current file to pdf

2013-04-14 Thread santosh subudhi
Hello Team I am looking for VBA code to print a active sheet into pdf without user interface. Suppose the cell AA1 contains the address where the pdf to be stored and Cell AA2 contains the name by which the pdf to be stored. -- Regards Santosh santoshkumar.subu...@gmail.com -- Are you

Re: $$Excel-Macros$$ Repeated row to be deleted

2013-04-14 Thread Chaya
Dear Pravin, Check the below if it will work out. and you can change the row number as you like. e.g. AL85 to AL5000 as per your data. Sub Remove_Duplicate() ' Removing Duplicate in c column. Application.ScreenUpdating = False Sheets(FNDWRR).Select Sheets(FNDWRR).Copy

Re: $$Excel-Macros$$ Repeated row to be deleted

2013-04-14 Thread Pravin Gunjal
Hi Chaya It must be check in col. B C and not only C. Pl check and inform. Regards Pravin. On Mon, Apr 15, 2013 at 11:08 AM, Chaya chayamon...@gmail.com wrote: Dear Pravin, Check the below if it will work out. and you can change the row number as you like. e.g. AL85 to AL5000 as per