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 came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.
You must log in or register to reply here.

Similar threads

G
  • Locked
  • Question Question
Printing excel chart in high quality
Replies
1
Views
92
Peter_SSs
Peter_SSs
C
  • Solved
Extracting data with VBA macro button from files in designated folder
2 3
Replies
20
Views
849
Micron
M
C
  • Solved
List Results from All Sheets Search
2
Replies
16
Views
214
MikeVol
MikeVol
A
  • Solved
VBA to copy a template from one sheet to another based on dropdown
2
Replies
10
Views
686
altizerc2196
A
A
  • Solved
VBA code to extract a table
Replies
5
Views
236
Anthony47
A

Forum statistics

Threads
1,223,885
Messages
6,175,186
Members
452,615
Latest member
bogeys2birdies

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