MACRO issue while extracting data

[hgbegdhegdh]

Hello,

I have excel file which extracts data from website ( moneycontrol.com ) Attached here with.

Problem is in BUTTON 4.

Now button 4 has stopped extracting data in COLUMN AZ

I want need help in
1. Extracting data in COLUMN AZ from ( moneycontrol.com ) LINK is provided in COLUMN E
2. I also want to extract data in CB and CC

I have attached screenshot of ( moneycontrol.com ) website of which data should come where

Providing you example of SCRIPT - SUNPHARMA
link of data: Sun Pharma Share Price, Sun Pharma Stock Price, Sun Pharmaceutical Industries Ltd. Stock Price, Share Price, Live BSE/NSE, Sun Pharmaceutical Industries Ltd. Bids Offers. Buy/Sell Sun Pharmaceutical Industries Ltd. news & tips, & F&O Quotes, NSE/BSE Forecast News and Live Quotes

see attached screenshots for more details

No.1 - should come in AZ
No.2 - should come in CB
No.3 - should come in CC

You can download Excel file from

Share Anything with pCloud

With pCloud's unique Download Link feature you can share files with everyone. Click to download. Join pCloud.com and get up to 20GB FREE cloud storage.

my.pcloud.com

Seniors please help

 

[hgbegdhegdh]

Seniors please reply