Well that is a beginning can you point me to someone who can write the macro?

Thanks

Rod
"Pete_UK" wrote:

Yes, it will be harder, but if there is a guaranteed blank row between
each record (and no other blank rows) then at least it is possible to
gather the data together for each record on one row. You might then
need to move some of the data horizontally to make room for missing
items of data, like an email address, but I think you can only do this
manually. You will need a macro for the first part.

Pete

On Feb 27, 5:04 pm, Rod Dakan
wrote:
There is a blank row between records, but if data is missing a blank cell is
not there. Dang that will make it harder.

Rod



"Pete_UK" wrote:
Is there a blank row between each record to help identify each block
of data? And if an item is missing, such as email address, will this
have a blank cell, or will the data be bunched up for each person?

Pete

On Feb 27, 4:38 pm, Rod Dakan <Rod
wrote:
I am not sure that this can be done but I am scanning a list of people,
address, city state and zip
I can get it into excel but haven't figured out how to get into a format
that will allow me to import it into a database.

The data looks like this in the spreadsheet.

Name first name other name
Company
Address (streee city st zip)
Phone
email
other info
even more info

I will have about 4000 names to deal with so some method of transposing all
of this would be a real help.

Even some suggestions as to software that will help would great.- Hide quoted text -

- Show quoted text -