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
1preferred contact method:preferred contact method:preferred contact method:
2
3emailtextphone
4phone
5textcontact name:
6contact name:
7contact name:Valentina
8contact by phone:
9Valentinacontact by phone:
10
☎​
8885055050
11contact by phone:
☎​
8885055050
12User's Email Address
13
☎​
8885055050
User's Email Address
14bob@smith.com
15User's Email AddressOur other sites
16Our other sites
17bob@smith.comsite1
18site2site1
19Our other sitessite3site2
20site3
21site1
22site2Email to copy and paste:
23site3Email to copy and paste:
24bob@smith.com
25
26Email to copy and paste:
27
28bob@smith.com
29
30Example 1Example 2Example 3

<tbody>
</tbody>
Results

TO HERE:
<b>Excel 2010</b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #BBB"><colgroup><col width="25px" style="background-color: #DAE7F5" /><col /><col /><col /></colgroup><thead><tr style=" background-color: #DAE7F5;text-align: center;color: #161120"><th></th><th>A</th><th>B</th><th>C</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">1</td><td style="font-weight: bold;;">Name</td><td style="font-weight: bold;;">Preferred Contact Method(s)</td><td style="font-weight: bold;;">Email Address</td></tr><tr ><td style="color: #161120;text-align: center;">2</td><td style=";">Bob Smith</td><td style=";">email, phone, text</td><td style=";">bob@smith.com</td></tr></tbody></table><p style="width:3.6em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid #BBB;border-top:none;text-align: center;background-color: #DAE7F5;color: #161120">Sheet1</p><br /><br />


---------

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.
 

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.

jeffcoleky

Active Member
Joined
May 24, 2011
Messages
274
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)
 

Forum statistics

Threads
1,143,656
Messages
5,720,116
Members
422,266
Latest member
Mattyw

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
Top