Need to format data pasted from website

[scourtney]

Hi everyone - first time users but long time admirer of Mr Excel
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
I have to construct a spreadsheet of company names/details and competencies.<o></o>
<o></o>
The data I'm collecting is available via a website which has over 1400 companies listed.<o></o>
<o></o>
All company names have been copied and pasted directly into excel, but the company details can only be access individually on the website by clicking on the name & opening an individual webpage (urgh!). I'm prepared to copy these individually as I'm being paid by the hour
<o></o>
The problem is getting them into the correct format (starting with the Company Name in column A and populating across the Row with the all the details (10-15 fields). Not all detail fields are provided in many cases...<o></o>
<o></o>
The data pasted from the website looks like this when pasted into excel:<o></o>
<o></o>
Contact person Data1<o></o>
Job Title Data2<o></o>
Address Data3<o></o>
City/Suburb Data4<o></o>
State Data5<o></o>
Operating State Data6<o></o>
Email Data7<o></o>
Phone Data8<o></o>
Fax Data9<o></o>
Website Data10<o></o>
<o></o>
I'm aiming to have the final excel output to look something like this:<o></o>
<o></o>
Name / Contact person / Job Title / Address / City/Suburb / State / Operating State / Email / Phone / Fax / Website
Company 1 Data1 Data2 Data3 Data4 Data5 Data6 Data7 Data8 Data9 Data10

<o></o>
Thanks in advance and hope this makes sense - and sorry if a similar thread has been posted - I tried to search but couldn't come up with anything.<o></o>
<o></o>
cheers,<o></o>
<o></o>
Scott<o></o>

 

[hiker95]

scourtney,

Welcome to the MrExcel forum.

What version of Excel are you using?

Can you post a screenshot of the raw data after you copy it into a worksheet?

And, can you post a screenshot of what the data should look like in another worksheet?

You will generally get much more help (and faster) in this forum if you can post your small samples (what you have and what you expect to achieve) directly in the forum.

To attach screenshots, see below in my Signature block: Post a screen shot with one of these:

 

[scourtney]

Hiker,

Thanks for taking the time to look at my problem.

I'm using Excel 2003 (SP3).

I've attempted to screenshot the Raw data and final output data using Excel-Jeanie as you suggested. Please let me know if this is ok?

cheers,

Scott

Raw data pasted from website:

VIC Data

<TABLE style="BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; FONT-FAMILY: Arial,Arial; FONT-SIZE: 10pt" border=1 cellSpacing=0 cellPadding=0><COLGROUP><COL style="WIDTH: 30px; FONT-WEIGHT: bold"><COL style="WIDTH: 85px"><COL style="WIDTH: 118px"></COLGROUP><TBODY><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt; FONT-WEIGHT: bold"><TD></TD><TD>A</TD><TD>B</TD></TR><TR style="HEIGHT: 34px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">2</TD><TD style="TEXT-ALIGN: left; FONT-WEIGHT: bold">Address</TD><TD>68 Henderson Road</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">3</TD><TD style="TEXT-ALIGN: left; FONT-WEIGHT: bold">City/Suburb</TD><TD>CLAYTON</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">4</TD><TD style="TEXT-ALIGN: left; FONT-WEIGHT: bold">State</TD><TD>Victoria</TD></TR><TR style="HEIGHT: 34px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">5</TD><TD style="TEXT-ALIGN: left; FONT-WEIGHT: bold">Email</TD><TD style="COLOR: #0000ff; TEXT-DECORATION: underline">sales@abcohc.com.au</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">6</TD><TD style="TEXT-ALIGN: left; FONT-WEIGHT: bold">Phone</TD><TD>61 3 9561 4199</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">7</TD><TD style="TEXT-ALIGN: left; FONT-WEIGHT: bold">Fax</TD><TD>61 3 9561 4699</TD></TR><TR style="HEIGHT: 34px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">8</TD><TD style="TEXT-ALIGN: left; FONT-WEIGHT: bold">Website</TD><TD style="COLOR: #0000ff; TEXT-DECORATION: underline">http://www.abcohc.com.au</TD></TR><TR style="HEIGHT: 34px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">9</TD><TD style="TEXT-ALIGN: left; FONT-WEIGHT: bold">Contact person</TD><TD>Dr Nina Webster</TD></TR><TR style="HEIGHT: 34px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">10</TD><TD style="TEXT-ALIGN: left; FONT-WEIGHT: bold">Job Title</TD><TD>Director, Business Development</TD></TR><TR style="HEIGHT: 34px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">11</TD><TD style="TEXT-ALIGN: left; FONT-WEIGHT: bold">Address</TD><TD>103-113 Stanley Steet</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">12</TD><TD style="TEXT-ALIGN: left; FONT-WEIGHT: bold">City/Suburb</TD><TD>West Melbourne</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">13</TD><TD style="TEXT-ALIGN: left; FONT-WEIGHT: bold">State</TD><TD>Victoria</TD></TR><TR style="HEIGHT: 34px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">14</TD><TD style="TEXT-ALIGN: left; FONT-WEIGHT: bold">Email</TD><TD style="COLOR: #0000ff; TEXT-DECORATION: underline">nina.webster@acrux.com.au</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">15</TD><TD style="TEXT-ALIGN: left; FONT-WEIGHT: bold">Phone</TD><TD>+61 3 8379 0123</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">16</TD><TD style="TEXT-ALIGN: left; FONT-WEIGHT: bold">Fax</TD><TD>+61 3 8379 0101</TD></TR><TR style="HEIGHT: 34px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">17</TD><TD style="TEXT-ALIGN: left; FONT-WEIGHT: bold">Website</TD><TD style="COLOR: #0000ff; TEXT-DECORATION: underline">http://www.acrux.com.au</TD></TR><TR style="HEIGHT: 34px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">18</TD><TD style="TEXT-ALIGN: left; FONT-WEIGHT: bold">Contact person</TD><TD>Samantha Cobb</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">19</TD><TD style="TEXT-ALIGN: left; FONT-WEIGHT: bold">Job Title</TD><TD>CEO</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">20</TD><TD style="TEXT-ALIGN: left; FONT-WEIGHT: bold">Address</TD><TD>15/2 Park Drive</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">21</TD><TD style="TEXT-ALIGN: left; FONT-WEIGHT: bold">City/Suburb</TD><TD>Bundoora</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">22</TD><TD style="TEXT-ALIGN: left; FONT-WEIGHT: bold">State</TD><TD>Victoria</TD></TR><TR style="HEIGHT: 34px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">23</TD><TD style="TEXT-ALIGN: left; FONT-WEIGHT: bold">Email</TD><TD style="COLOR: #0000ff; TEXT-DECORATION: underline">s.cobb@adalta.com.au</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">24</TD><TD style="TEXT-ALIGN: left; FONT-WEIGHT: bold">Phone</TD><TD>+61 3 9479 5159</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">25</TD><TD style="TEXT-ALIGN: left; FONT-WEIGHT: bold">Fax</TD><TD>+61 3 9479 3666</TD></TR><TR style="HEIGHT: 34px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">26</TD><TD style="TEXT-ALIGN: left; FONT-WEIGHT: bold">Website</TD><TD style="COLOR: #0000ff; TEXT-DECORATION: underline">http://www.adalta.com.au</TD></TR><TR style="HEIGHT: 34px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">27</TD><TD style="TEXT-ALIGN: left; FONT-WEIGHT: bold">Contact person</TD><TD>Robin Coleman</TD></TR><TR style="HEIGHT: 51px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">28</TD><TD style="TEXT-ALIGN: left; FONT-WEIGHT: bold">Job Title</TD><TD>Business Development Director</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">29</TD><TD style="TEXT-ALIGN: left; FONT-WEIGHT: bold">Address</TD><TD>1 Dalmore Drive</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">30</TD><TD style="TEXT-ALIGN: left; FONT-WEIGHT: bold">City/Suburb</TD><TD>Scoresby</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">31</TD><TD style="TEXT-ALIGN: left; FONT-WEIGHT: bold">State</TD><TD>Victoria</TD></TR><TR style="HEIGHT: 34px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">32</TD><TD style="TEXT-ALIGN: left; FONT-WEIGHT: bold">Email</TD><TD style="COLOR: #0000ff; TEXT-DECORATION: underline">rcoleman@advent-pharma.com</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">33</TD><TD style="TEXT-ALIGN: left; FONT-WEIGHT: bold">Phone</TD><TD>+61 3 9763 9966</TD></TR><TR style="HEIGHT: 34px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">34</TD><TD style="TEXT-ALIGN: left; FONT-WEIGHT: bold">Contact person</TD><TD>Jeffrey Luckins</TD></TR><TR style="HEIGHT: 34px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">35</TD><TD style="TEXT-ALIGN: left; FONT-WEIGHT: bold">Job Title</TD><TD>Company Secretary</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">36</TD><TD style="TEXT-ALIGN: left; FONT-WEIGHT: bold">Address</TD><TD>465 Auburn Road,</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">37</TD><TD style="TEXT-ALIGN: left; FONT-WEIGHT: bold">City/Suburb</TD><TD>Hawthorn</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">38</TD><TD style="TEXT-ALIGN: left; FONT-WEIGHT: bold">State</TD><TD>Victoria</TD></TR><TR style="HEIGHT: 34px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">39</TD><TD style="TEXT-ALIGN: left; FONT-WEIGHT: bold">Email</TD><TD style="COLOR: #0000ff; TEXT-DECORATION: underline">jluckins@agenix.com</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">40</TD><TD style="TEXT-ALIGN: left; FONT-WEIGHT: bold">Phone</TD><TD>03 9822 8686</TD></TR><TR style="HEIGHT: 34px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">41</TD><TD style="TEXT-ALIGN: left; FONT-WEIGHT: bold">Website</TD><TD>http:// www.agenix.com</TD></TR><TR< a>style="height:34px ;" ><TR><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">42</TD><TD style="TEXT-ALIGN: left; FONT-WEIGHT: bold">Contact person</TD><TD>Ian Smith</TD></TR><TR style="HEIGHT: 51px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">43</TD><TD style="TEXT-ALIGN: left; FONT-WEIGHT: bold">Job Title</TD><TD>Director (Finance and Service Testing)</TD></TR><TR style="HEIGHT: 34px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">44</TD><TD style="TEXT-ALIGN: left; FONT-WEIGHT: bold">Address</TD><TD>60-66 Hanover Street</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">45</TD><TD style="TEXT-ALIGN: left; FONT-WEIGHT: bold">City/Suburb</TD><TD>Fitzroy,</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">46</TD><TD style="TEXT-ALIGN: left; FONT-WEIGHT: bold">State</TD><TD>Victoria</TD></TR><TR style="HEIGHT: 34px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">47</TD><TD style="TEXT-ALIGN: left; FONT-WEIGHT: bold">Email</TD><TD style="COLOR: #0000ff; TEXT-DECORATION: underline">info@aggenomics.com.au</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">48</TD><TD style="TEXT-ALIGN: left; FONT-WEIGHT: bold">Phone</TD><TD>+61 3 8412 7066</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">49</TD><TD style="TEXT-ALIGN: left; FONT-WEIGHT: bold">Fax</TD><TD>+61 3 9416 4076</TD></TR><TR style="HEIGHT: 34px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">50</TD><TD style="TEXT-ALIGN: left; FONT-WEIGHT: bold">Website</TD><TD style="COLOR: #0000ff; TEXT-DECORATION: underline">http://www.aggenomics.com.au</TD></TR><TR style="HEIGHT: 34px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">51</TD><TD style="TEXT-ALIGN: left; FONT-WEIGHT: bold">Contact person</TD><TD>Sue Broughton</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">52</TD><TD style="TEXT-ALIGN: left; FONT-WEIGHT: bold">Job Title</TD><TD>Marcom Specialist</TD></TR><TR style="HEIGHT: 34px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">53</TD><TD style="TEXT-ALIGN: left; FONT-WEIGHT: bold">Address</TD><TD>347 Burwood Highway</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">54</TD><TD style="TEXT-ALIGN: left; FONT-WEIGHT: bold">City/Suburb</TD><TD>Forest Hill</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">55</TD><TD style="TEXT-ALIGN: left; FONT-WEIGHT: bold">State</TD><TD>Victoria</TD></TR><TR style="HEIGHT: 34px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">56</TD><TD style="TEXT-ALIGN: left; FONT-WEIGHT: bold">Email</TD><TD style="COLOR: #0000ff; TEXT-DECORATION: underline">Sue_broughton@agilent.com</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">57</TD><TD style="TEXT-ALIGN: left; FONT-WEIGHT: bold">Phone</TD><TD>1800 802 402</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">58</TD><TD style="TEXT-ALIGN: left; FONT-WEIGHT: bold">Fax</TD><TD>+61 3 9210 5474</TD></TR><TR style="HEIGHT: 34px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">59</TD><TD style="TEXT-ALIGN: left; FONT-WEIGHT: bold">Website</TD><TD style="COLOR: #0000ff; TEXT-DECORATION: underline">http://www.agilent.com/chem</TD></TR></TBODY></TABLE>

Excel tables to the web >> http://www.excel-jeanie-html.de/index.php?f=1" target="_blank"> Excel Jeanie HTML 4

Output Data as required:

Final Directory


<TABLE style="BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; FONT-FAMILY: Arial,Arial; FONT-SIZE: 10pt" border=1 cellSpacing=0 cellPadding=0><COLGROUP><COL style="WIDTH: 30px; FONT-WEIGHT: bold"><COL style="WIDTH: 264px"><COL style="WIDTH: 85px"><COL style="WIDTH: 114px"><COL style="WIDTH: 136px"><COL style="WIDTH: 135px"><COL style="WIDTH: 109px"><COL style="WIDTH: 60px"><COL style="WIDTH: 156px"><COL style="WIDTH: 82px"><COL style="WIDTH: 67px"><COL style="WIDTH: 148px"></COLGROUP><TBODY><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt; FONT-WEIGHT: bold"><TD></TD><TD>A</TD><TD>B</TD><TD>C</TD><TD>D</TD><TD>E</TD><TD>F</TD><TD>G</TD><TD>H</TD><TD>I</TD><TD>J</TD><TD>K</TD></TR><TR style="HEIGHT: 40px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">1</TD><TD style="TEXT-ALIGN: left; FONT-SIZE: 11pt; FONT-WEIGHT: bold">Name</TD><TD style="TEXT-ALIGN: left; FONT-SIZE: 11pt; FONT-WEIGHT: bold">Territory</TD><TD style="TEXT-ALIGN: left; FONT-SIZE: 11pt; FONT-WEIGHT: bold">Contact person</TD><TD style="TEXT-ALIGN: left; FONT-SIZE: 11pt; FONT-WEIGHT: bold">Job Title</TD><TD style="TEXT-ALIGN: left; FONT-SIZE: 11pt; FONT-WEIGHT: bold">Address</TD><TD style="TEXT-ALIGN: left; FONT-SIZE: 11pt; FONT-WEIGHT: bold">City/Suburb</TD><TD style="TEXT-ALIGN: left; FONT-SIZE: 11pt; FONT-WEIGHT: bold">State</TD><TD style="TEXT-ALIGN: left; FONT-SIZE: 11pt; FONT-WEIGHT: bold">Email</TD><TD style="TEXT-ALIGN: left; FONT-SIZE: 11pt; FONT-WEIGHT: bold">Phone</TD><TD style="TEXT-ALIGN: left; FONT-SIZE: 11pt; FONT-WEIGHT: bold">Fax</TD><TD style="TEXT-ALIGN: left; FONT-SIZE: 11pt; FONT-WEIGHT: bold">Website</TD></TR><TR style="HEIGHT: 34px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">6</TD><TD>ABCO Health Care Pty Ltd</TD><TD>VIC</TD><TD></TD><TD></TD><TD>68 Henderson Road</TD><TD>CLAYTON</TD><TD>Victoria</TD><TD style="COLOR: #0000ff; TEXT-DECORATION: underline">sales@abcohc.com.au</TD><TD>61 3 9561 4199</TD><TD>61 3 9561 4699</TD><TD style="COLOR: #0000ff; TEXT-DECORATION: underline">http://www.abcohc.com.au</TD></TR><TR style="HEIGHT: 34px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">9</TD><TD>Acrux Ltd</TD><TD>VIC</TD><TD>Dr Nina Webster</TD><TD>Director, Business Development</TD><TD>103-113 Stanley Steet</TD><TD>West Melbourne</TD><TD>Victoria</TD><TD style="COLOR: #0000ff; TEXT-DECORATION: underline">nina.webster@acrux.com.au</TD><TD>+61 3 8379 0123</TD><TD>+61 3 8379 0101</TD><TD style="COLOR: #0000ff; TEXT-DECORATION: underline">http://www.acrux.com.au</TD></TR><TR style="HEIGHT: 34px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">13</TD><TD>AdAlta Pty Ltd</TD><TD>VIC</TD><TD>Samantha Cobb</TD><TD>CEO</TD><TD>15/2 Park Drive</TD><TD>Bundoora</TD><TD>Victoria</TD><TD style="COLOR: #0000ff; TEXT-DECORATION: underline">s.cobb@adalta.com.au</TD><TD>+61 3 9479 5159</TD><TD>+61 3 9479 3666</TD><TD style="COLOR: #0000ff; TEXT-DECORATION: underline">http://www.adalta.com.au</TD></TR><TR style="HEIGHT: 34px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">23</TD><TD>Advent Pharmaceuticals Pty Ltd</TD><TD>VIC</TD><TD>Robin Coleman</TD><TD>Business Development Director</TD><TD>1 Dalmore Drive</TD><TD>Scoresby</TD><TD>Victoria</TD><TD style="COLOR: #0000ff; TEXT-DECORATION: underline">rcoleman@advent-pharma.com</TD><TD>+61 3 9763 9966</TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 34px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">28</TD><TD>Agenix Limited</TD><TD>VIC</TD><TD>Jeffrey Luckins</TD><TD>Company Secretary</TD><TD>465 Auburn Road,</TD><TD>Hawthorn</TD><TD>Victoria</TD><TD style="COLOR: #0000ff; TEXT-DECORATION: underline">jluckins@agenix.com</TD><TD>03 9822 8686</TD><TD></TD><TD style="COLOR: #0000ff; TEXT-DECORATION: underline">http://www.agenix.com</TD></TR><TR style="HEIGHT: 34px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">29</TD><TD>AgGenomics Pty Ltd</TD><TD>VIC</TD><TD>Ian Smith</TD><TD>Director (Finance and Service Testing)</TD><TD>60-66 Hanover Street</TD><TD>Fitzroy,</TD><TD>Victoria</TD><TD style="COLOR: #0000ff; TEXT-DECORATION: underline">info@aggenomics.com.au</TD><TD>+61 3 8412 7066</TD><TD>+61 3 9416 4076</TD><TD style="COLOR: #0000ff; TEXT-DECORATION: underline">http://www.aggenomics.com.au</TD></TR><TR style="HEIGHT: 34px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">31</TD><TD>Agilent Technologies</TD><TD>VIC</TD><TD>Sue Broughton</TD><TD>Marcom Specialist</TD><TD>347 Burwood Highway</TD><TD>Forest Hill</TD><TD>Victoria</TD><TD style="COLOR: #0000ff; TEXT-DECORATION: underline">Sue_broughton@agilent.com</TD><TD>1800 802 402</TD><TD>+61 3 9210 5474</TD><TD style="COLOR: #0000ff; TEXT-DECORATION: underline">http://www.agilent.com/chem</TD></TR></TBODY></TABLE>


Excel tables to the web >> http://www.excel-jeanie-html.de/index.php?f=1" target="_blank"> Excel Jeanie HTML 4

 

[hiker95]

scourtney,

Thanks for the two screenshots.

We are missing the following information in the screenshot for worksheet VIC Data:
Name
Territory


Can we try a different approach:

See below in my Signature block: You can upload your workbook to Box Net, and provide us with a link to your workbook.