Do you mean converting the form results to CSV or XML before importing
as Anne Troy suggested above? Any tips on the best way to do that?

Re the offset method you mention, I went and did as you describe - got
to the stage where the cells were set up and then I didn't know what to
do? How to get the data in??

Please excuse my profound ignorance....

Ed Ferrero Wrote:
Hi antfarm,

Answer to both questions is yes.

You can probably make things a bit easier for yourself by sending the
formmail survey data to some sort of text datafile. Then import that
to
Excel.

Keep in mind importing XML data into Excel is now very easy.

Or, if the client already has emails in the format below, use the
OFFSET
method that I described in the thread "Convert data from rows to
columns"
earlier in this newsgroup.


--
antfarm
------------------------------------------------------------------------
antfarm's Profile: http://www.excelforum.com/member.php...o&userid=24661
View this thread: http://www.excelforum.com/showthread...hreadid=382394