How to get website results in to excel

G

guhanath

New Member
Joined
Mar 18, 2009
Messages
4
Hi,

I have a problem,

i want to get the data from one web site (internet) by running the multiple inputs which are input feed to that website (in the website have only one input box) via excel cell. in the web site, after giving one input data in to text box,and then after click on the 'go' button, the result will be shown in tablular format. i want this reslut in excel by giving the multiple inputs execute at a time. For Ex:

In the web site we have:
___
Login Name : | Text box | |go|
---
Result Table:
----------------------------------------
|Name | address | city | designation |
----------------------------------------
|AAAA |BBBBB |CCCC | DDDDDD |
----------------------------------------
|AAAA |EEEEE |FFFF | GGGGGG |
----------------------------------------

In Excel:

----------------------------------------------
|A |B | C |D
----------------------------------------------
|AAAA | | |
----------------------------------------------
|BBBB | | |
----------------------------------------------
|CCCC | | |
----------------------------------------------

By giving the above input via excel and it will run the website and get the values and pull the reslut data in to another sheet or same sheet in some other cell.like below(another sheet)

------------------------------------------------
|A |B | C |D
------------------------------------------------
|AAAA |BBBBB |CCCC | DDDDDD
------------------------------------------------
|AAAA |EEEEE |FFFF | GGGGGG
------------------------------------------------
|BBBB |BBBBB |CCCC | DDDDDD
------------------------------------------------
|BBBB |EEEEE |FFFF | GGGGGG
------------------------------------------------
|CCCC |BBBBB |CCCC | DDDDDD
------------------------------------------------
|CCCC |EEEEE |FFFF | GGGGGG
------------------------------------------------

Please help me to get this... Thanks in advance.

Regards,
Nath.
 

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college
Sort by date Sort by votes
You must log in or register to reply here.

Similar threads

N
  • Question Question
Excel - Get data from webpage based on input
Replies
0
Views
458
nidzesi
N
L
  • Solved
VBA to automate getting table from website to excel daily
2
Replies
10
Views
3K
John_w
J
MrDB4Excel
  • Solved
DuckDuckGo Conditional Format
2
Replies
12
Views
741
MrDB4Excel
MrDB4Excel
D
  • Question Question
Can't get MailMerge to work through VBA
Replies
0
Views
241
DetroitJimBurke
D
B
  • Solved
Barcode Scan result is errant in MS Excel, good data in Notepad/G Sheets
Replies
2
Views
3K
bmoreskimore
B

Forum statistics

Threads
1,222,312
Messages
6,165,268
Members
451,949
Latest member
bovacik

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