VBA to draw data from websites on chrome, filter that data by keywords and make the keyword equal to specific value in adjacent cell

V

vanini

New Member
Joined
Mar 12, 2018
Messages
1
Hi all

I am trying to draw data from a webpage, i need to get that data into excel and make a search (e.g. India, United States, China) run automatically on the data so that when a keyword is found, it is equivalent to a specific value (e.g. Indian Rupee, USD, Chinese Yuan).

Help please Im very desperate for answers

Thank you in advance!
 

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.
You must log in or register to reply here.

Similar threads

A
  • Question Question
Excel data from one sheet, copy cells from row i'm working on to excel 'form' based on cell value
Replies
2
Views
545
asiuol84
A
J
  • Question Question
Power Query editor OR VBA to extract data from Grants.gov
Replies
3
Views
389
Jagadeshrao
J
M
  • Question Question
Sort and Filter data copied from website with merged cells
Replies
2
Views
349
matty2k_3
M
R
  • Question Question
Insert data from two worksheets into master workbook and match values
Replies
0
Views
1K
RandomUserCode
R
J
  • Question Question
Trying to write and Excel VBA for searching a list of text strings for keywords based on an array and then writing specific values to adjacent cells
Replies
7
Views
984
Fluff
Fluff

Forum statistics

Threads
1,224,823
Messages
6,181,178
Members
453,021
Latest member
Justyna P

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