Please Help All kinds of problems

  • Thread starter Thread starter Darin
  • Start date Start date
D

Darin

Hello, Thanks in advance
I am somewhat new at excel but I am signing up for some classes next week so
this won't happen again. What I would like to do is take the data we collect
from public records mainly Building Permits for 8 counties. Each county has
a different way of giving me the information some give it to me in a Excel
Spreadsheet, I get some in Word and some in other formats I don't know the
name of them, I was told the program that some of them use was developed
just for them. These counties will not email me the information I get plus
some can't give it to me in until the last minute it and it comes in snail
mail or I have to go get it then retype it.(This is what I don't want to do
but I don't want to pay someone to enter it either) Then I give it to my
boss and he uploads it to our site.There can be anywhere from 5 to 27
fields of info again each county gives me a different amount in a different
format. So it can be anywhere from 1200 to 2500 rows of information each
month to enter.With 5 to 27 different fields.

So I started to scan the information in with readiris last night and all was
going good while I was scanning the excel spreadsheets but when I scan the
others all the information comes out in excel but it is all in 1 or 2
columns straight down.

So question 1

Can I scan this type of information in an when it comes out it can be in the
format I need.

Can I fix my current problem or am I going to have to type it in now.

I would like any suggestions on how I might make this work smoothly.

web site is www.mymarketinfo.com Jefferson County Kentucky has the most
information Jeffersonville Ind has the least.
I all so would like input on making the site as user friendly as possible.
The main idea is the end customer can sort the information by what ever they
want and the don't have to go through all hassle and paper work that I have
to thought . They will be able to sort by Builder,Zip, Street quickly.
Thanks Again
Thanks
 
Darin,
Are you familiar with "Text to Columns" in Excel? This would solve the
problem of your scanned info in excel being in one or two columns. Very easy
to use once you have tried it a few times. If you are not familiar with this
comand I would recommend trying it first with a small amount of info.
Go to:
Data
Text to Columns

Example:
A1
Thomas Frank, D.D.S. Inc.

Put curser in A1 and go to data > text to columns adn follow directions.
Hope this helps.
 
Darin,
Are you familiar with "Text to Columns" in Excel? This would solve the
problem of your scanned info in excel being in one or two columns. Very easy
to use once you have tried it a few times. If you are not familiar with this
comand I would recommend trying it first with a small amount of info.
Go to:
Data
Text to Columns

Example:
A1
Thomas Frank, D.D.S. Inc.

Put curser in A1 and go to data > text to columns adn follow directions.
Hope this helps.
Click to expand...
Hi,

I've worked for government before so I know this may not be practical but it
might be a good idea to develop a standardized excel worksheet that includes
all your fields. Then you would have your information in a logical format
and reports would be easy to generate. I'm an accountant and I find that a
well designed spreadsheet can save you hours of tearing your hair out.

bye

Darlene
 
Back
Top