Contactform Dataprocessing to Excel

[MaasR]

Hey Guys,

I am in a bit of a bind here. I've build a website for a neighbor of mine who owns a store selling clothes. The site has a contact form to allow people to submit their information in order to build a customer database. The data is forwarded by a standard form script and emailed to an account which presents the data to me as followed:

QUOTE
Name = "Input"
Lastname = "Input"
Adres = "Input"

etc etc

I want to copy that data into an excel sheet but so far I’ve only been able to copy this data into individual cells. Ideally I'd have the data classification e.g. name surname etc horizontally and then the input data underneath that.
Don't have that much experience with excel but I heard it's possible.

Running Excell 2007 on vista.

Thanks in advance :D.

[Huron]

One way of doing it would be to have an input area in your spreadsheet where you paste the data from the email then formulas in the next column

Please Login or Register  to view this content.

would extract the "input" part. You could then copy these 3 cells and use Paste Special - Values - Transpose to paste into a table. When the next email arrives you paste over the existing data in the input area but paste the results in the next blank row of the table.

See attached example.

[MaasR]

Cheers this saves me quite a bit of work, thanks for your help Huron :D.