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 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
Macro to copy and paste selected raws.xls
Description: MS-Excel spreadsheet
