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

Reply via email to