![]() ![]() ![]() The Google Sheet link and VBA code in that file. I have uploaded an excel file, namely the "Source.xlsm", here. Maybe other considerations can proceed if this post can be solved.īut for the time being, I need your help to:ġ) Data from "Testing Spreadsheet" Sheet1 B3:C5 exported to the "Source.xlsm" Sheet1 B3:C5Ģ) Data from "Testing Spreadsheet" Sheet2 E3:F6 exported to the "Source.xlsm" Sheet2 E3:F6ģ) Then, if we refresh or update the "Source.xlsm", the data can be replaced on the same cells. The green icon next to the file name means that the file. Now if you upload the Excel file to Google Drive, it will be automatically converted to Google Sheets. In the Settings window, check Convert uploaded files to Google Docs editor format and click Done. I have several considerations about this task, but I plan to solve them one by one. In the top right corner of Google Drive, click the Settings icon, and choose Settings. However, as I declared earlier, I have no basic about VBA, and I am only able to change the link address and run the script/code. So, I found a code/script on the internet. Yes, Excel has a "Get Data" tool, but it could not paste the specific cell or data. ![]() I want to copy the specific cells/data from Google Sheet to the Excel Desktop using VBA. My asking is quite long, but I try to make it as short as possible. But I need a code/script to solve my problem. First, apologize because I have no basic about the VBA. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |