R
robertfhilliii
I am attempting to copy financial data from one worksheet to another.
Unfortunately, the worksheet that I am copying from is formatted as
one column of data in column A. The data appears as follows in column
A:
DISTRICT: Adams County/Ohio Valley Local COUNTY: Adams IRN:
061903
ADM, VALUATION & MILLAGE (1983-1984) SOURCE:
SF12
Line 3 Basic ADM 4,916 Assessed value
480,468,317
Total ADM 5,769 Valuation/Basic ADM
97,736
Voted millage (Incl JVS) 20.80 Class1 eff tax
rate 20.14
BASIC STATE AID (1983-1984) SOURCE:
SF12
Adj Basic Aid 0.00 DPIA
957,432.00
State basic aid 1,675,815.24 Total Basic Support
2,633,247.24
CATEGORICAL SUPPORT (1983-1984) SOURCE:
SF12
Vocational 1,024,384.31 Ext services
35,163.87
Special education 23,130.55 Transportation
588,949.20
Gifted 0.00 Total categorical
2,052,846.53
DBECN and EMR
381,218.60
TOTAL STATE SUPPORT (1983-1984) SOURCE:
SF12
State basic support 2,633,247.24 Total SF-12
4,349,738.02
Total categorical
2,052,846.53
I need to pull out specific numbers from this worksheet and paste them
into a specific labeled column in a second worksheet. The data
involves financial data for school districts in Ohio for the years
1980-1994. Copying and pasting back and forth is extremely time
consuming. My second worksheet contains the following column headings:
IRN, DISTRICT, COUNTY, ADM, Per Pupil Property Valuation, Federal
Funds, Total Current Expenditure, Total, Per Pupil Expenditure.
I want to copy the following values for each of the 600 plus districts
in the state of Ohio from 1980-2004. Each year is on a separate
worksheet:
copy value for "valuation/adm" to "per pupil property valuation"
copy value for "federal funds" to "federal funds"
copy value for "total current expenditures" to "total current
expenditures"
Each value must match the correct district when copying from the
original worksheet to my second worksheet.
Can anyone suggest a visual basic code to complete this task?
Thanks,
Bob
Unfortunately, the worksheet that I am copying from is formatted as
one column of data in column A. The data appears as follows in column
A:
DISTRICT: Adams County/Ohio Valley Local COUNTY: Adams IRN:
061903
ADM, VALUATION & MILLAGE (1983-1984) SOURCE:
SF12
Line 3 Basic ADM 4,916 Assessed value
480,468,317
Total ADM 5,769 Valuation/Basic ADM
97,736
Voted millage (Incl JVS) 20.80 Class1 eff tax
rate 20.14
BASIC STATE AID (1983-1984) SOURCE:
SF12
Adj Basic Aid 0.00 DPIA
957,432.00
State basic aid 1,675,815.24 Total Basic Support
2,633,247.24
CATEGORICAL SUPPORT (1983-1984) SOURCE:
SF12
Vocational 1,024,384.31 Ext services
35,163.87
Special education 23,130.55 Transportation
588,949.20
Gifted 0.00 Total categorical
2,052,846.53
DBECN and EMR
381,218.60
TOTAL STATE SUPPORT (1983-1984) SOURCE:
SF12
State basic support 2,633,247.24 Total SF-12
4,349,738.02
Total categorical
2,052,846.53
I need to pull out specific numbers from this worksheet and paste them
into a specific labeled column in a second worksheet. The data
involves financial data for school districts in Ohio for the years
1980-1994. Copying and pasting back and forth is extremely time
consuming. My second worksheet contains the following column headings:
IRN, DISTRICT, COUNTY, ADM, Per Pupil Property Valuation, Federal
Funds, Total Current Expenditure, Total, Per Pupil Expenditure.
I want to copy the following values for each of the 600 plus districts
in the state of Ohio from 1980-2004. Each year is on a separate
worksheet:
copy value for "valuation/adm" to "per pupil property valuation"
copy value for "federal funds" to "federal funds"
copy value for "total current expenditures" to "total current
expenditures"
Each value must match the correct district when copying from the
original worksheet to my second worksheet.
Can anyone suggest a visual basic code to complete this task?
Thanks,
Bob