Import multiple tables from a website

T

triggacray

New Member
Joined
Jun 4, 2015
Messages
1
Greetings,

I need to import multiple tables that are located on multiple pages from the following site:

Error Codes > Canon

Can anyone assist?

If you click on a machine, it shows the error codes for that particular machine. Some of the error codes are on 1 page and some are on 12 pages. Copy and paste would take years. Please help me :)
 

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
You must log in or register to reply here.

Similar threads

F
  • Question
Checking for Page Breaks Multiple Times
Replies
2
Views
403
Shloime
S
J
  • Question
Using VBA Power Query to import PDF tables
Replies
2
Views
3K
RoryA
RoryA
N
  • Question
Need help with organizing processes to proceed. Project / Challenge.
Replies
3
Views
271
noveske
N
L
  • Solved
Importing data from one excel workbook to another
Replies
2
Views
498
londa_vba
L
B
  • Question
VBA to extract data from multiple folders and add to a master workbook plus identifying tags
Replies
2
Views
853
John_w
J

Forum statistics

Threads
1,214,593
Messages
6,120,434
Members
448,961
Latest member
nzskater

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