Stop copy paste. Get data from website using Excel or Power BI - using Power Query (Get and Transform). Once the data is imported, you can refresh it instantly.
No need to copy paste repeatedly.
Contents
00:00 Import from web page table
01:56 Import from web page which does not have a table
Buy Dr Nitin's latest book
-----------------------------------------
Efficiency Best Practices for Microsoft 365
130 best practices everyone must know
Work Smarter, Grow Faster
https://s.efficiency365.com/bk
Dr Nitin's Office Masterclass
----------------------------------------------
https://hi.switchy.io/mms
Udemy Courses by Dr Nitin Paranjape
--------------------------------------------------------------
Pivot Table Advanced - https://hi.switchy.io/22B1
Excel to Power BI - https://swiy.io/pivotsh
Learn more from 1000+ blog articles by Dr Nitin Paranjape
https://efficiency365.com/blog
LinkedIn : / nitinparanjape
Twitter : / drnitinp
Created using Camtasia: https://www.techsmith.com/video-editor