You can help yourself learn. Record a macr while select your range>data>filter>filter by date>copy/paste to other sheet>unfilter.
clean it up to use for next time. Post back your results Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: pawel lupinski Sent: Monday, March 12, 2012 8:02 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ help on copy and past data needed Hi All, I need your help on this one, please help. What I need to do on weekly base I need to copy the report (like the one in "REPORT" tab)and find the date from "B2" cell in "DATA" tab (if their match, if not so just taking the next one) and after when I find it, it just copy cells from "REPORT" tab (here "A2:P32) and paste in the "DATA" tab in the pleace that is most relevant. Can anyone can help me and create the macro that can do it for me, please it will save me a lot of thime through a day. Thanks in advance, Pawel -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com
