vba code that can copy datas from diff. sheet to an empty column with a search key data.

i need a vba code that can get the data from a different sheet using a data from a column. if it matched the data then we can get the desired data and copy paste it to the targetted range or column..

heres a code i used.. its unfinished yet.. and its not dynamic.. if the user inserts a column / rows the program gets messed up.. so i need a program that uses range and tables so that even if the user inserts column.. the range is untouched...

Please Login or Register  to view this content.

...Bump...