Morshed_Dhaka
New Member
- Joined
- Dec 16, 2016
- Messages
- 42
Hi All,
Below is my problem:
I have a excel file which have 8 different sheets and eachsheets contains a table of data which range is “D6: Q2926”. In every sheet ofthose 8 sheets, same range data is available and that sheet is uploaded togoogle docs for editing.
Now for security purpose, I am not able to installing googledrive to my laptop as because it is official. But I need a macro which willpull updated data from that uploaded google sheet file and save it to the savedfile in laptop. Which means, same file in 2 places. 1 is in google sheet and 1is in local laptop. If data is being updated into the google sheet file, thenwhen I open the local file in the laptop all the data of all the sheets will beupdated. Is there any code available?? Please, help
Below is my problem:
I have a excel file which have 8 different sheets and eachsheets contains a table of data which range is “D6: Q2926”. In every sheet ofthose 8 sheets, same range data is available and that sheet is uploaded togoogle docs for editing.
Now for security purpose, I am not able to installing googledrive to my laptop as because it is official. But I need a macro which willpull updated data from that uploaded google sheet file and save it to the savedfile in laptop. Which means, same file in 2 places. 1 is in google sheet and 1is in local laptop. If data is being updated into the google sheet file, thenwhen I open the local file in the laptop all the data of all the sheets will beupdated. Is there any code available?? Please, help