Search multiple values and copy below cell to next sheet

Search multiple values and copy below cell to next sheet

References

Reference NO 1

http://stackoverflow.com/questions/15201392/search-multiple-values-and-copy-below-cell-to-next-sheet

Reference NO 2

http://stackoverflow.com/questions/12591563/excel-vba-search-for-multiple-phrase-copy-to-single-sheet-across-multiple-shee

Reference NO 3

http://excel.bigresource.com/Search-Find-Multiple-Cell-Values-On-Another-Worksheet-0M0q4fKb.html

Reference NO 4

http://www.ozgrid.com/forum/showthread.php?t=163868

Reference NO 5

http://www.rondebruin.nl/win/s9/win006.htm

Reference NO 6

http://office.microsoft.com/en-us/excel-help/more-ways-to-use-hlookup-and-vlookup-functions-HA001056549.aspx

Reference NO 7

http://www.myonlinetraininghub.com/excel-factor-17-lookup-and-return-multiple-matches

Reference NO 8

#EANF#