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 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
