You are welcome. . . Regards, DILIPandey
On 7/2/11, Atul <atul_pate...@yahoo.com> wrote: > 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 > -- Sent from my mobile device Thanks & Regards, DILIP KUMAR PANDEY, mvp MBA,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India -- ---------------------------------------------------------------------------------- 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
