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 calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.
You must log in or register to reply here.

Similar threads

M
  • Locked
  • Question
Importing table from Web with multiple pages but page address its not changed when going to other table
Replies
1
Views
526
Peter_SSs
Peter_SSs
N
  • Question
Using VBA to copy data from Webpage table to excel
Replies
2
Views
5K
New_Grasshopper
N
M
  • Question
Importing table from Web with multiple pages but page address its not changed when going to other table
Replies
0
Views
453
mike monnnnnnnnn
M
D
  • Solved
Cell lookup - based on range and two other cells
Replies
5
Views
313
Peter_SSs
Peter_SSs
A
  • Question
Need VBA code to copy/paste data from one sheet to another with multiple criteria and complex structure
Replies
0
Views
1K
Amir Wisal
A

Forum statistics

Threads
1,196,498
Messages
6,015,556
Members
441,900
Latest member
Inaschemitex2023

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