I took "no more information" to mean that you did not want to keep it after we have completed each task. The following will send the B2 value to the J6 range of the linked worksheet in Column A until there are no more entries in Column B, and then erase the entire original set.
Please make a copy of your workbook and test the following on your copy. VBA is difficult to undo and a few simple precautionary steps can save you time and a headache.
If it is not your wish to erase the original data, replace:
of the above with:
which will simply navigate you back home.
-HTH-
Bookmarks