Extracting information from Column A to Column B Automatically

[Mstg007]

I am trying to automatically extract / copy information from Column A to Column B.
But the hard part is to automatically define what rows i want extract or copy from Column A.

ColA ColB
a
b
c
d
e
f
g_line
1 1
2 2
3 3
4 4
5 5
6 6
7 7
8 8
9 9
10 10
h_curve
i
j
f
l
m
I am importing a file into excel. So there might be even more than 100 of the numbers I want to copy over.
From (a to g_line) will always be constant - its the header of the imported file. But from h_curve to m is consistant -
its the bottom header of the file. So 1 - 10 (or 1 - 1000) I would want to copy or extract over to Column B.
Thanks for your help!!!!

 

[Mstg007]

what I am trying to do is to take the data into a import_sheet and replace values from another calc_sheet within the workbook. I wanted to spilt the values up so they would populate into calc_sheet. Then, in the other calc_sheet, I could do calcs. If the calcs I do - do not work with the data, it would replace it with the corrected calc data back into the import_sheet.