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:
<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:
---------
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.
A | A | A | |
---|---|---|---|
preferred contact method: | preferred contact method: | preferred contact method: | |
text | phone | ||
phone | |||
text | contact name: | ||
contact name: | |||
contact name: | Valentina | ||
contact by phone: | |||
Valentina | contact by phone: | ||
☎ 8885055050 | |||
contact by phone: | ☎ 8885055050 | ||
User's Email Address | |||
☎ 8885055050 | User's Email Address | ||
bob@smith.com | |||
User's Email Address | Our other sites | ||
Our other sites | |||
bob@smith.com | site1 | ||
site2 | site1 | ||
Our other sites | site3 | site2 | |
site3 | |||
site1 | |||
site2 | Email to copy and paste: | ||
site3 | Email 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>
TO HERE:
Excel 2010 | |||||
---|---|---|---|---|---|
A | B | C | |||
1 | Name | Preferred Contact Method(s) | Email Address | ||
2 | Bob Smith | email, phone, text | bob@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.