I have been given the task of populating a spreadsheet with contact information (e.g. street address, city, zip, phone, fax). I am looking up the info on a web site and copying it as formatted and pasting it into a cell of a spreadsheet. There are seven lines of data and data from six of them goes into a different cells. I also have to ignore some of the data.

I recorded my keystrokes into a Macro using Relative References. The data gets put in the correct cells but the macro also remembers all the data. This results in the same data in all the cells. Did I do something wrong? Is this possible using a Macro for this task? Also, is there anohter way? I thought of an array but am not skilled enough to know how to do this without spending too much time on it.

This entire job will take about 10 hours if toally manual. If I can shave off 5 or 6 hours, I'm all for it. So far, I have already spend an hour too much trying to figure out why the Macro isn't working *simle*

I tried this in Excel 2003 and 2007.

Any help would be appreciated.

Example of Cell text after paste from web, before Macro is run:

123 any street --> in cell a6
Anytown, IL 65656 --> ignore
555-666-6789 --> in cell a7
District Office:--> ignore
345 another street suite 111 --> in cell a9
Other Town, IL 65656 --> in cell a10, ignore ", IL" and put zip in a11
444-333-2121 --> in cell a12