Puling Data from a website using VBA's

[bswdimples]

I am trying to go on this site:https://www.sparefoot.com/Brooklyn-NY-self-storage/StorageMart-Kent-Ave-Wallabout-70426

And pull data so I can get a report with the below informationColumn 1: Unit sizeColumn 2: AmenitiesColumn 3: PriceColumn 4: Promotion Any guidance is appreciated!

 

[Ombir]

Where these columns are located on the web page ??????

 

[Marmit424]

Hi bsw,

Scraping data from a website typically involves either Power Query (now integrated into Excel 2016) or a significant amount of fairly complex VBA. Have you spent any time exploring either of these routes?