Search & copy macro not showing actual result. Can someone help me please

[john5599]

Hi

I got a Macro from but it is not showing accurate result in this sample file. Can someone help me please as it is need me .


Thanks in advance

Here is the link of sample file. Please help me

https://www.dropbox.com/s/jt3fqffo3bj80ix/BooK325.xlsm?dl=0

 

[Fluff]

As you have told us absolutely nothing whatsoever this is a guess.
Make this change

          nxtDst_rw = Sheets(2).Range("[COLOR=#ff0000]B[/COLOR]" & Rows.Count).End(xlUp).Row + 1

If that doesn't work, then please explain what you are trying to do & why the macro is not working.

 

[john5599]

Ok thanks. Its working

 

[Fluff]

You're welcome & thanks for the feedback