Hyperlink if statement to pick and transpose data

nobita_bk06

New Member
Joined
Jan 1, 2018
Messages
1
Hello everyone,

I have been working on a sheet that contains the companies profile.

The data I got from another source, the sheet consists of only one column. the Company Name cell is hyperlinked to their homepage.
Following that cell are the other information. The most difficulty is the following information of companies are not the same size. I need to transpose it to row and collect the data from this sheet.

My idea is that using the hyperlink if statement to pick the name of company and transpose the following cell to another sheet until another hyperlinked cell is met and repeat the process.

the example is depicted in the following table. Is there anyone who has faced this issue? Any help is appreciated. Thank you so much.

Công ty TNHH Namidori Footwear

<colgroup><col></colgroup><tbody>
</tbody>
Add: 30/3A đường 35, KP5, P. Bình Trưng Tây, Q.2, Tp. Hồ Chí Minh
Director:Đào Ngọc Anh
Tel:0985519830
Email:namidorishoes@gmail.com
Công ty TNHH American & Efird Việt Nam

<colgroup><col></colgroup><tbody>
</tbody>
Add: Lầu 2, 7 Lý Tự Trọng, P. Bến Nghé, Quận 1, HCM

<tbody>
</tbody>

Director:Juok Kim
Tel:02862962929
Email:thuyle@amefird.com.vn
Add:No 103G1, Pham Van Dong Road, Anh Dung Ward, Duong Kinh District, Hai Phong City, Vietnam
HCR One Member Co., LTD

<colgroup><col></colgroup><tbody>
</tbody>
Add:20 -Hiep Binh,Hiep Binh Phuoc,Thu Duc,Ho Chi Minh
Tel: (84) 37273643
(84) 37273644
Email: hoangdonghcr@gmail.com

<tbody>
</tbody>
 

Some videos you may like

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.

Watch MrExcel Video

Forum statistics

Threads
1,122,842
Messages
5,598,394
Members
414,234
Latest member
grlevesq

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