We have a customer at work who wants us to start billing in a 500
character edi format.

What that means is basically we need to take our bill and create a 500
character long string from each line.

Most of the characters in this "string" do not change however the
billing code, description, labor rate, material charge, etc will
alternate.

What I need to do is use our existing spreadsheet because the format is
used for our billing system and have another spreadsheet that pulls in
the work code, description, costs, etc and throw it in place with the
500 character line, merge it and kick it out in ascii.

Here is a small "dummy" example with the fields that I would need to
pull in highlighted in red:

1GATX12050562478640800905EINTERIORRUBBERLINING0000 000000000000000047290018500S000950RR0000000000000


I hope I explained it well enough. Is this even possible? Thanks in
advance for your input.


--
denileigh
------------------------------------------------------------------------
denileigh's Profile: http://www.excelforum.com/member.php...o&userid=30211
View this thread: http://www.excelforum.com/showthread...hreadid=498927