Import non-tabular data from multiple pages in website. Please help.

R

Ritz_999

New Member
Joined
Nov 7, 2016
Messages
3
Hi friends,

I need to import all the data for various companies in each state, each region and their details in excel. Unfortunately the data is not in tabular form (unlike other threads were tabular data import codes are mentioned).

https://pin-code.org.in/companies/listing

I do not know much of macros/VBA but it is practically impossible to visit each page and put in excel.

Request anyone from this forum to please help me with the codes to import this data. Please help!
 

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney
Sort by date Sort by votes
No help yet :(.... I had lot of hope from this forum.
I have to prepare the report today.......

somebody pls help.....
 
Upvote 0
You must log in or register to reply here.

Similar threads

K
  • Question Question
Import Data from Multiple Web Pages
Replies
0
Views
235
Ka001
K
T
  • Solved
Import Data Starting from next empty row
Replies
7
Views
468
Tanne
T
C
  • Solved
Extracting data with VBA macro button from files in designated folder
2 3
Replies
20
Views
788
Micron
M
D
  • Question Question
Importing data from web source
Replies
0
Views
844
Devvy
D
A
  • Question Question
Take screenshots & simultaneously capture the link, place it into an Excel file which is linked to a FileMaker/Claris db.
Replies
3
Views
382
Dan_W
D

Forum statistics

Threads
1,223,715
Messages
6,174,064
Members
452,542
Latest member
Bricklin

Share this page

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