Presumably you're referring to: http://www.vbaexpress.com/forum/show...l=1#post257696
If you're wanting to send the data to a specific worksheet, change:
Set WkSht = ActiveSheet
to, for example:
Set WkSht = Sheets("Employees")
If you want the data to start populating in Column B instead of Column A, change:
j = 0
to:
j = 1