Write steps to copy data from a range of cells to another range of cells in a different worksheet
within the same workbook. Use an example for writing the steps.
Answers
Answered by
1
Answer:
Explanation:
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
Sheets(“DataTable”).Select
Step 4: Select the cell where you want to begin the paste, in this case we use A1.
Range(“A1”).Select
Step 5: Paste the data
Activesheet.Paste
So putting it all together leaves us with the VBA Script looking like:
Sub CopyData()
Sheets(“ImportSheet”).Select
Answered by
1
Explanation:
skalalalpwdewlsllslslalalalallalalala
sa
s
a
a
a
a
a
a
a
a
a
a
a
a
a
a
a
a
a
a
a
a
a
Similar questions