Data transfer from online excel to offline excel only specfic columns

[KAMRAN AJ]

Hi,everyone hope you are doing great
I want to transfer specific column data from my online excel to offline excel dynamic range.
In the screenshot, I have shown you online excel data and how I can transfer it offline to excel dynamic range automatically
for better understanding, I have attached a youtube video link for you.

https://www.youtube.com/watch?v=Sv1_eZYcd5Q


here I also attached an example video link what I want you can see

https://www.youtube.com/watch?v=V6dNzy1RATE


Can we can do this Excel with Vba code ?oh let suppose i transfer this online excel sheet to offline then run a macro to seperate a specfic columns

if you need further detail please tell me i will help you