1. There is no data in columns A and B. It does not
matter because the data from C and D wil be pasted over it.
2. Yes, the data comes from the first county row, usually
after "County Non-Migrants"
3. The numbers for "number of returns" are completely
hypothetical. I just need soem advice on designing a
macro for the copied information to stop at "county non-
migrants".
4. The post is there, but listed as anonymous
"Copied Pair Info to Different Number..."
-----Original Message-----
1. In your first example, what data is already in columns
A and B? Or does
it not matter? Are you wanting to overwrite whatever is
there?
2. In your second example, is the data in columns A and B
simply the data
from the first county listed and copied down the rest of
the rows in that
same group (to the row that contains "County Non-
Migrants")?
3. How do the numbers add up?
4. I don't see your previous post on 4/13. Did you post
it to a different
newsgroup?
--
Regards,
Bill
"Alex"
wrote in message
...
(Previously posted, on April 13 3:45PM, but I am not
well
trained in VB and really NEED a precise code for a
Macro)
PLease help!!!
I am working on old county out-migration flow datasets.
The datasets are for in-migration into a specific
county.
For example, a typical file includes many in-migration
counties.
row
below
C D E F <-column
1 To To From County Name Number
2 St. Co of
3 <Blank cells in row Returns
4 <Blank row
5 30 017 Custer 10
6 30 111 Yellowstone 6
7 30 031 Gallatin 2
8 Same State 8
9 Diff Region 7
10 30 017 County Non-Migrants 13
11 30 019 Daniels 17
12 30 162 Missula 8
13 30 033 King 4
14 30 031 Gallatin 5
15 Same State 2
16 Diff Region 9
17 30 019 County Non-Migrants 16
I want to make a macro that takes the first numbers by
the
cell right below a "County Non-Migrants" and copies them
to the next "County Non-Migrants," taking into account
that the number of rows is not constant.
Example of End Result:
A B C D E F
From From To To County Name Number
St. Co St. Co of
<Blank cells in row Returns
<Blank row
30 017 30 017 Custer 10
30 017 30 111 Yellowstone 6
30 017 30 031 Gallatin 2
30 017 Same State 8
30 017 Diff Region 7
30 017 30 017 County Non-Migrants 13
30 019 30 019 Daniels 17
30 019 30 162 Missula 8
30 019 30 033 King 4
30 019 30 031 Gallatin 5
30 019 Same State 2
30 019 Diff Region 9
30 019 30 019 County Non-Migrants 16
The problem I see is that the rows are not constant.
How
would you write a complex if statement to take into
account the "county non-migrants" information?
Thanks for your help. (By the way, I have thousands
rows
of cells of this type of information for over 10 years
with cells for each county in three states. A lot of
work
for a long time if I have to the procedure manually.)
.