Macro: Search and then copy the result and paste into Excel

S

Siops

Board Regular
Joined
Sep 8, 2011
Messages
80
Hello. Please help me if it is possible to do a macro. I have a list in Column A1-1000 and I need to search one by one from a website and then based on the result, I need to copy the result under the second table and paste it in my Excel file (maybe in another sheet).

Here is the example screenshot of the website and I need the result under the "Opportunities".

I've been trying to do a manual task so please help me if this is possible via macro. Thank you so much in advance!

Also asked here Macro: Search from a website and then copy the result and paste into Excel
 

Attachments

  • Test.JPG
    Test.JPG
    93.5 KB · Views: 19
Last edited by a moderator:

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.
You must log in or register to reply here.

Similar threads

G
  • Locked
  • Question Question
Printing excel chart in high quality
Replies
1
Views
72
Peter_SSs
Peter_SSs
C
  • Solved
Extracting data with VBA macro button from files in designated folder
2 3
Replies
20
Views
708
Micron
M
A
  • Solved
VBA to copy a template from one sheet to another based on dropdown
2
Replies
10
Views
675
altizerc2196
A
A
  • Solved
VBA code to extract a table
Replies
5
Views
163
Anthony47
A
K
  • Question Question
Writing a Macro
Replies
2
Views
80
MikeVol
MikeVol

Forum statistics

Threads
1,223,227
Messages
6,170,848
Members
452,361
Latest member
d3ad3y3

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