Quote Originally Posted by OBP View Post
You also do not have any headings in the Sheet, do you have a sheet with the correct headings, or an Access table?
The field names can be anything - but pls don't worry - I should be able to figure it out - just struggling w/syntax.

However this is how I see the table right now but very flexible & open to suggestions

County/City ' these 3 will be from first column using REGEX to separate county/city from Name -
Company ' the following fields that I'm likely going to concat to make name
DBA
Address ' this and following fields will be populated by CASE
SALES
PHONE
EMPLOYEES
SIC
NEW RECORD
SQ FT
FAX
WEB
DBA
P.O
PA:
HQ:
MISC1 'these are for
MISC2
MISC3
MISC4
MISC5
MISC6
MISC7
MISC8
MISC9
MISC10