MACRO Help: FIND and COPY Specific contact information from another sheet?

jeffcoleky

Active Member
Joined
May 24, 2011
Messages
274
I'm trying to grab the data from the "Results" tab, which contains data in rows, and put it in Sheet1 in columns. The data will ALWAYS be in [Results] Column A, but the catch is that the row number that contains the data isn't always the same.Data goes from here:
AAA
preferred contact method:preferred contact method:preferred contact method:
emailtextphone
phone
textcontact name:
contact name:
contact name:Valentina
contact by phone:
Valentinacontact by phone:
☎​
8885055050
contact by phone:
☎​
8885055050
User's Email Address
☎​
8885055050
User's Email Address
bob@smith.com
User's Email AddressOur other sites
Our other sites
bob@smith.comsite1
site2site1
Our other sitessite3site2
site3
site1
site2Email to copy and paste:
site3Email to copy and paste:
bob@smith.com
Email to copy and paste:
bob@smith.com

<tbody>
[TD="align: center"]1[/TD]

[TD="align: center"]2[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]3[/TD]

[TD="align: center"]4[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]5[/TD]

[TD="align: right"][/TD]

[TD="align: center"]6[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]7[/TD]

[TD="align: right"][/TD]

[TD="align: center"]8[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]9[/TD]

[TD="align: right"][/TD]

[TD="align: center"]10[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]11[/TD]

[TD="align: right"][/TD]

[TD="align: center"]12[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]13[/TD]

[TD="align: right"][/TD]

[TD="align: center"]14[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]15[/TD]

[TD="align: right"][/TD]

[TD="align: center"]16[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]17[/TD]

[TD="align: right"][/TD]

[TD="align: center"]18[/TD]
[TD="align: right"][/TD]

[TD="align: center"]19[/TD]

[TD="align: center"]20[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]21[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]22[/TD]

[TD="align: right"][/TD]

[TD="align: center"]23[/TD]

[TD="align: right"][/TD]

[TD="align: center"]24[/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]

[TD="align: center"]25[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]26[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]27[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]28[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]29[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]30[/TD]
[TD="bgcolor: #FFFF00, align: center"]Example 1[/TD]
[TD="bgcolor: #FFFF00, align: center"]Example 2[/TD]
[TD="bgcolor: #FFFF00, align: center"]Example 3[/TD]

</tbody>
Results

TO HERE:

Excel 2010
ABC
1NamePreferred Contact Method(s)Email Address
2Bob Smithemail, phone, textbob@smith.com
Sheet1



---------

I'd like to run a macro to pull the data from Results:A:A into the Currently selected Row on Sheet 1, (as it is above).

Some things are always true:
1) Phone number always has a "☎ " symbol in front of it and is always two rows below "contact by phone:"
2) Contact name is always two rows below the "Contact Name" text, IF it is present.
3) User's Email Address is always two rows below the "User's Email Address" text, IF it is present.
4) the order in which they are displayed doesn't change.
5) There will always only be one email, phone, or name associated with each record.

Here is a sample file

Is this enough info for someone to help me create such a macro? Any help or suggestions offered shall be MUCH appreciated.
 
Would it help facilitate an answer if I simplified the question?

Using a script, how do I copy and paste an email address from another sheet if I don't know which row it is on? (but do know which column)
 
Upvote 0

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top