This is a doozie of a problem, and I was hoping someone with a
little more experience could help me out.
My boss has commissioned me to create a cvs file from excel to be
used as a mailing list for our company. It will include something like
rows of first and last names, phone numbers, address, etc with
information gathered from several sources.
How do I create a template where I can import another workbook and
have say, column H from that transfered to column G in the template
automatically, etc, and also have it place the 6th and 7th digits of
one column into another (i.e. D5 from the import is '4398710983' which
puts '10' into D5 in the template)? Any assistance on this would be
greatly appreciated.. -Mike