Thnaks you Pandeyji. ITs working fine On Jun 29, 2:45 am, Dilip Pandey <dilipan...@gmail.com> wrote: > Hi Atul, > > You were clear in the first email itself. It is my mistake that I had > overlooked the point. > Now I have revised the macro and it should work fine. > > Feel free to get back in case of any queries. Thanks. > > Regards, > DILIPandey > > On 6/29/11, Atul <atul_pate...@yahoo.com> wrote: > > > > > > > Hi Dilipji, > > > Thank you for your response. > > > It seems that macro is hidiing weekends and holidays upon copying raws > > to the new file. > > > Actually, I need macro to copy over only the first business day of > > each month for atleast next months. For that reason I highlighted > > selected raws in yellow. The ultimate result should contain only one > > raw for each month being the first business day of respective month. > > > Please modify macro appropriately. I hope I could make it clear this > > time. > > > Apology if it was not clear on earler email. > > > Atul > > > On Jun 27, 2:51 am, Dilip Pandey <dilipan...@gmail.com> wrote: > >> Hi Atul, > > >> Please find a quick solution attached herewith :) > >> Feel free to get back in case of any queries. > > >> Regards, > >> DILIPandey > > >> On 6/27/11, Atul Patel <atul_pate...@yahoo.com> wrote: > > >> > Attachment to my request. > > >> > Attached is a sample file. I need a macro code to copy selected raws > >> > (yellow highlighted) from the liquidity tab of a given spreadsheet and > >> > paste to other file say 'Book1'. The selection criteria would be based > >> > on Column A. I want to copy first working day of each month. the > >> > day should not be either saturday, sunday or holidays. (you can have > >> > list of holidays on other tab approx 10 days in a given calendar year) > > >> > Per my understanidng this task can be done other way also, copy entire > >> > spread sheet to Book1 and delete unwanted raws ( means raws not > >> > matching above criteria) > > >> > Much wiill be appreciated if some one help me this. > > >> > Thanks, > > >> > Atul > > >> > Atul Patel > >> > 905 785 8324(H) > >> > 647 898 4074(C) > >> > atul_pate...@yahoo.com > >> > atul_danga...@rediffmail.com > > >> > Good to know you ! > > >> > -- > >> > ---------------------------------------------------------------------------------- > >> > 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 athttp://www.excel-macros.blogspot.com > >> > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > >> > 5. Excel Tips and Tricks athttp://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, > > >> DILIP KUMAR PANDEY, mvp > >> MBA,B.Com(Hons),BCA > >> Mobile: +91 9810929744 > >> dilipan...@gmail.com > >> dilipan...@yahoo.com > >> New Delhi - 62, India > > >> Macro to copy and paste selected raws.xls > >> 55KViewDownload- Hide quoted text - > > >> - Show quoted text - > > > -- > > ---------------------------------------------------------------------------------- > > 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 athttp://www.excel-macros.blogspot.com > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > > 5. Excel Tips and Tricks athttp://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, > > DILIP KUMAR PANDEY, mvp > MBA,B.Com(Hons),BCA > Mobile: +91 9810929744 > dilipan...@gmail.com > dilipan...@yahoo.com > New Delhi - 62, India > > Macro to copy and paste 1st BD.xls > 65KViewDownload- Hide quoted text - > > - Show quoted text -
-- ---------------------------------------------------------------------------------- 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
