hi there i would like some assistance with a vba solution that copies and pastes the contents from multiple webpages into sheet 1.
My workbook has 2 sheets, "Microsoft Platforms" and sheet1. The Microsoft Platforms sheet contains a list of Microsoft certifications by platform, by certification name and number eg Azure Administrator Associate, AZ-104, etc. there is a hyperlink to Microsoft.com for each certification in Column D. I have to regularly open each link and check the exam certification name, price and exam date (ie check that it has not been retired).
What i would like is a macro that looks at column D ( End(XlUp).Row) cycle through each link and open each link and copy and past the entire webpage into sheet 1 from starting at cell a1, then b1, then c1 till end.
acknowledge this isnt a need process however get dat web import in both excel and power bi have not been successful.
as the results will be uniform i can then look up the columns data and update the Microsoft Platforms sheet. ie exam certification name should be in row 8, retirement date row 40 and price in row 44 etc..
a typical link = Exam AZ-500: Microsoft Azure Security Technologies - Learn
Ack the macro would have to clear contents of sheet 1 each time the macro is activated.
i would appreciate any assistance.
My workbook has 2 sheets, "Microsoft Platforms" and sheet1. The Microsoft Platforms sheet contains a list of Microsoft certifications by platform, by certification name and number eg Azure Administrator Associate, AZ-104, etc. there is a hyperlink to Microsoft.com for each certification in Column D. I have to regularly open each link and check the exam certification name, price and exam date (ie check that it has not been retired).
What i would like is a macro that looks at column D ( End(XlUp).Row) cycle through each link and open each link and copy and past the entire webpage into sheet 1 from starting at cell a1, then b1, then c1 till end.
acknowledge this isnt a need process however get dat web import in both excel and power bi have not been successful.
as the results will be uniform i can then look up the columns data and update the Microsoft Platforms sheet. ie exam certification name should be in row 8, retirement date row 40 and price in row 44 etc..
a typical link = Exam AZ-500: Microsoft Azure Security Technologies - Learn
Ack the macro would have to clear contents of sheet 1 each time the macro is activated.
i would appreciate any assistance.