Build the macro shorter

[nur2544]

Dear all, This macro works for copy only data form one sheet to another sheet . is it possible to make it more shorter ?

Please Login or Register  to view this content.

[AB33]

Please Login or Register  to view this content.

[nur2544]

Hi, AB33 , Thanks for replay , your macro suppose to work but here not working for my case ? would you please check once again.

[AB33]

It may not find the cells, hence it jumps in to next line

Please Login or Register  to view this content.

OR

Please Login or Register  to view this content.

[nur2544]

Hi, AB33 , yes !! your 2nd macro is working very well. thanks for your valuable time in this regards..