Best way to load data from Excel sheet into a browser page?

C

Chartist

Board Regular
Joined
Apr 2, 2007
Messages
138
Office Version
  1. 365
Platform
  1. Windows
I have data in an Excel sheet and a hyperlink corresponding to each record (row). I click the link in the Excel cell and it opens a new tab in Chrome.

The webpage has fields which need to be filled using the data in the Excel sheet. I'm currently copy-pasting this from the Excel sheet to the webpage I just opened.

What's the best way to auto-fill the webpage with the data in Excel? (Hopefully something in Excel/VBA, but otherwise how do I go about this requirement?)

Thanks!
 

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.
You must log in or register to reply here.

Similar threads

Anigito
  • Question
Get Webpage Title Text by URL Generated in MS Excel
Replies
1
Views
432
Anigito
Anigito
M
  • Solved
Hyperlinks in Excel
Replies
2
Views
212
Mr_Phil
M
L
  • Question
How to Save File from Webpage using VBA
Replies
1
Views
1K
Anthony47
A
M
  • Question
Open webpage, copy all and paste in Excel
Replies
1
Views
1K
Billy Hill
B
F
  • Solved
Webscraping a site with no element ids and returning data
Replies
6
Views
1K
fizzydrink
F

Forum statistics

Threads
1,215,042
Messages
6,122,810
Members
449,095
Latest member
m_smith_solihull

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