Excel data in one cell, need to copy specific values to another worksheet in different cells


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
 
Ad

Advertisements

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

The data does not appear in straight lines as shown in the post, so
the "text to column" function does not work.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top