This is Crazy. How To Copy And Paste 66 Data Using Google Chrome with Macro

Corried

Board Regular
Joined
Dec 19, 2019
Messages
169
Office Version
  1. 2019
Platform
  1. Windows
  2. Web
Hello excel forum. I have a problem. I am not sure if excel can do this…



Below. I have a list of 66 web link on worksheet tab “Bond”. Beginning on Cell N2. (See sample worksheet link below).

Each web link data is copied from website and is paste into a table, beginning in Cell B2 & B3. In other words. Each link represents two cells. “Date & Value” and continue downwards. (see example).

Example: Just to highlight a few…

Column AColumn B (Date)Column c (Value)Column N (Web Link)
Argentina1/3/202157.05
Australia1/3/202168.235
Austria1/3/2021875.69


The problem is, how can I copy and paste data?

Below you can view the photos of one web link example of the three steps process to copy the data.

Once you understand the first steps. The other links follow the same process… Please view photos below…

Step #1. To change daily data to weekly data. Please see photo highlighted in red...

Weekly.jpg


The next photo is highlighted in black. Data is copied and paste: Date (Jan 03, 2021) to paste in CellB2 & Price (57.05) paste into Cell C2.
2.JPG

I am not sure if you can help me. How can you all point me to the right direction?

Thanks in advance.
Australia 10-Year Bond Historical Data - Investing.com
https://www.investing.com/rates-bonds/austria-10-year-bond-yield-historical-dat
Belgium 10-Year Bond Historical Data - Investing.com
China 10-Year Bond Historical Data - Investing.com
Malaysia 10-Year Bond Historical Data - Investing.com
Malta 10-Year Bond Historical Data - Investing.com
Mauritius 10-Year Bond Historical Data - Investing.com
Mexico 10-Year Bond Historical Data - Investing.com
Morocco 10-Year Bond Historical Data - Investing.com
Namibia 10-Year Bond Historical Data - Investing.com
Netherlands 10-Year Bond Historical Data - Investing.com
New Zealand 10-Year Bond Historical Data - Investing.com
Nigeria 10-Year Bond Historical Data - Investing.com
Norway 10-Year Bond Historical Data - Investing.com
Pakistan 10-Year Bond Historical Data - Investing.com
Peru 10 Year Bond Historical Data - Investing.com
Philippines 10-Year Bond Historical Data - Investing.com
Poland 10-Year Bond Historical Data - Investing.com
Portugal 10-Year Bond Historical Data - Investing.com
Qatar 10-Year Bond Historical Data - Investing.com
Romania 10-Year Bond Historical Data - Investing.com
Russia 10-Year Bond Historical Data - Investing.com
Serbia 10 Year Bond Historical Data - Investing.com
Singapore 10-Year Bond Historical Data - Investing.com
Slovakia 10-Year Bond Historical Data - Investing.com
Slovenia 10-Year Bond Historical Data - Investing.com
South Africa 10-Year Bond Historical Data - Investing.com
South Korea 10-Year Bond Historical Data - Investing.com
Spain 10-Year Bond Historical Data - Investing.com
Sri Lanka 10-Year Bond Historical Data - Investing.com
Switzerland 10-Year Bond Historical Data - Investing.com
Taiwan 10-Year Bond Historical Data - Investing.com
Thailand 10-Year Bond Historical Data - Investing.com
Turkey 10-Year Bond Historical Data - Investing.com
Uganda 10-Year Bond Historical Data - Investing.com
Ukraine 3-Year Bond Historical Data - Investing.com
United Kingdom 10-Year Bond Historical Data - Investing.com
United States 10-Year Bond Historical Data - Investing.com
Vietnam 10-Year Bond Historical Data - Investing.com
 

Some videos you may like

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
55,241
Office Version
  1. 365
Platform
  1. Windows
Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Google Chrome using Macro
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.
 

Corried

Board Regular
Joined
Dec 19, 2019
Messages
169
Office Version
  1. 2019
Platform
  1. Windows
  2. Web
Mr. Fluff I am sorry. I would not happen again... What do you suggest I do?

Thanks in advance
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
55,241
Office Version
  1. 365
Platform
  1. Windows
Have you posted this anywhere other than XlGuru? If so post the links.
 

Watch MrExcel Video

Forum statistics

Threads
1,126,971
Messages
5,621,891
Members
415,864
Latest member
cybid

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
Top