Question: how to copy data between sheets in excel vba?
Answer: Step 1: Make sure the “ImportSheet” is selected. Sheets(“ImportSheet”).Select.
Step 2: Copy the range of data we need. Range(“A1:C14”).Copy.
Step 3: Select the “DataTable” sheet where we are moving the data. ... 
Step 4: Select the cell where you want to begin the paste, in this case we use A1. ... 
Step 5: Paste the data.