Copy in a filter mode the desired data then use paste special (alt e s v ) and select skip blank option. Hope fully it will solve ur queries.
Sandeep Chhajer. Sent on my BlackBerryŽ from Vodafone -----Original Message----- From: "dguillett1" <dguille...@gmail.com> Sender: excel-macros@googlegroups.com Date: Thu, 10 Nov 2011 07:25:57 To: <excel-macros@googlegroups.com> Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ help me Post your file Don Guillett SalesAid Software dguille...@gmail.com From: vijayajith VA Sent: Thursday, November 10, 2011 6:11 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ help me HI I have some datas in tab with coloumns(code and name) in one more tab with same datas but some names are missing .. so i need to filter the and paste the data. but if i paste the datas it will not paste completely .why i dont want to use vlookup is thr any shortcuts Thanks -- FORUM RULES (934+ 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 (934+ 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 (934+ 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