Not sure why you don't want a vlookup. Suggest using that, or using a
macro, given that all cells are the same order.
Sub GetMissingData()
Dim lngLoop As Long
For lngLoop = Cells(Rows.Count, 1).End(xlUp).Row To 2 Step -1
If IsEmpty(Cells(lngLoop, 2)) Then
Cells(lngLoop, 2).Value = Worksheets("Sheet2").Cells(lngLoop,
2).Value
End If
Next lngLoop
End Sub
Regards,
Sam Mathai Chacko
On Thu, Nov 10, 2011 at 7:42 PM, vijayajith VA <vijayajith...@gmail.com>wrote:
> hi
>
> I have tried using pastespecial its NOT WORKING
> its copying only two cells
>
> can you help me please ?
>
> Pleas find the attachment
>
> Thank you
>
>
> On Thu, Nov 10, 2011 at 7:41 PM, vijayajith VA <vijayajith...@gmail.com>wrote:
>
>>
>> hi
>>
>> I have tried using pastespecial but its not working
>>
>> its copying only two cells
>>
>> can you help me please ?
>>
>> Pleas find the attachment
>>
>> Thank you
>>
>> On Thu, Nov 10, 2011 at 7:01 PM, <chhajersand...@gmail.com> wrote:
>>
>>> 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
>>> ------------------------------
>>> *From: * "dguillett1" <dguille...@gmail.com>
>>> *Sender: * excel-macros@googlegroups.com
>>> *Date: *Thu, 10 Nov 2011 07:25:57 -0600
>>> *To: *<excel-macros@googlegroups.com>
>>> *ReplyTo: * excel-macros@googlegroups.com
>>> *Subject: *Re: $$Excel-Macros$$ help me
>>>
>>> Post your file
>>>
>>> Don Guillett
>>> SalesAid Software
>>> dguille...@gmail.com
>>>
>>> *From:* vijayajith VA <vijayajith...@gmail.com>
>>> *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
>>>
>>
>>
> --
> 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
>
--
Sam Mathai Chacko
--
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
