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

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.
Sort by date Sort by votes
You must log in or register to reply here.

Similar threads

N
  • Question
Excel - Get data from webpage based on input
Replies
0
Views
394
nidzesi
N
L
  • Solved
VBA to automate getting table from website to excel daily
2
Replies
10
Views
2K
John_w
J
B
  • Solved
Barcode Scan result is errant in MS Excel, good data in Notepad/G Sheets
Replies
2
Views
2K
bmoreskimore
B
P
  • Question
Excel Blood Pressure & Heart Rate AVG?
2
Replies
14
Views
3K
Dave Patton
D
C
  • Question
Replacing PowerPoint Input using Find and Replace Arrays from Excel through VBA
Replies
0
Views
1K
ckcs
C

Forum statistics

Threads
1,214,614
Messages
6,120,517
Members
448,968
Latest member
Ajax40

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