Register now or log in to join your professional community.
My Suggestion for you is to prepare the document using Microsoft excel then upload it to google drive and use the google sheet only to view the file.
I don't prefer google sheet for regular use.
agree with answers .........................................
agree with great answer given by ms. ghada
Thanks for the invite, I apologize for the answer, I leave the answer to the specialists.
I AGREE WITH THE ANSWER GIVEN BY Ghada Eweda Medical sales hospital representative AND ALL THE TEAM MEMBERS.
In moving from Excel to Google Spreadsheets, some may find the need to work with data or ranges from one spreadsheet in another spreadsheet by using formulas and not manually copying the data into multiple sheets, sometimes this is called linking Google spreadsheets.
Google does provide a solution to this via the ImportRange function, however there is still more to learn and know about this function, and it is best to start with the help from Google.(https://support.google.com/drive/table/25273?page=table.cs&rd=3)
Now that you have probably read the Google support notes on the ImportRange function, here are some tips and notes via examples on how it works:
(please note the spreadsheet links are not valid, and only for illustration purposes)Spreadsheet1 – https://docs.google.com/spreadsheet/ccc?key=0Ak__Spreadsheet1__ZoUzRhNFBIaGo2WXk3eFZPU1E#gid=0There are two sheets named Sheet1 and Sheet2
Spreadsheet2 – https://docs.google.com/spreadsheet/ccc?key=0Ak__Spreadsheet2__XaBC1LaDdSd1EzblQ1N3BBcWc#gid=0There are two sheets named SALES and EXPENSESThere are named ranges called SALES_SUMMARY, MONTHLY_SALES
TIP: The name of the sheet and named/protected range within the file is NOT case-sensitive
Using a new spreadsheet of your own creation, I will try to give you some good examples of how to pull data from another Google Spreadsheet.Examples of getting data from file Spreadsheet1, sheet named Sheet1=ImportRange(“0Ak__Spreadsheet1__ZoUzRhNFBIaGo2WXk3eFZPU1E”,”A1″)=ImportRange(“0Ak__Spreadsheet1__ZoUzRhNFBIaGo2WXk3eFZPU1E”,”A1:D1″)=ImportRange(“0Ak__Spreadsheet1__ZoUzRhNFBIaGo2WXk3eFZPU1E”,”sheet1!A1:B1″)
Examples of getting data from file Spreadsheet1, sheet named Sheet2NOTE: If you are not accessing the FIRST sheet created, you must specify the sheet name!=ImportRange(“0Ak__Spreadsheet1__ZoUzRhNFBIaGo2WXk3eFZPU1E”,”sheet2!A1″)=ImportRange(“0Ak__Spreadsheet1__ZoUzRhNFBIaGo2WXk3eFZPU1E”,”sheet2!A1:D1″)
Examples of getting data from file Spreadsheet2, sheet named SALES=ImportRange(“0Ak__Spreadsheet2__XaBC1LaDdSd1EzblQ1N3BBcWc”,”A5:F5″)=ImportRange(“0Ak__Spreadsheet2__XaBC1LaDdSd1EzblQ1N3BBcWc”,”sales!A5:F5″)=ImportRange(“0Ak__Spreadsheet2__XaBC1LaDdSd1EzblQ1N3BBcWc”,”SALES!A6″)
Examples of getting data from file Spreadsheet2, sheet named EXPENSES=ImportRange(“0Ak__Spreadsheet2__XaBC1LaDdSd1EzblQ1N3BBcWc”,”expenses!A5:F5″)=ImportRange(“0Ak__Spreadsheet2__XaBC1LaDdSd1EzblQ1N3BBcWc”,”Expenses!A5:F5″)=ImportRange(“0Ak__Spreadsheet2__XaBC1LaDdSd1EzblQ1N3BBcWc”,”EXPENSES!A6″)
Examples of getting data from file Spreadsheet2, named range SALES_SUMMARY=ImportRange(“0Ak__Spreadsheet2__XaBC1LaDdSd1EzblQ1N3BBcWc”,”SALES_SUMMARY”)=ImportRange(“0Ak__Spreadsheet2__XaBC1LaDdSd1EzblQ1N3BBcWc”,”Sales_Summary”)
Examples of getting data from file Spreadsheet2, named range MONTHLY_SALESNOTE: You can use the ImportRange Function inside of some functions, but not VLOOKUPTo use VLOOKUP, you must basically pull that data into the same file (optionally in a new sheet), then do a VLOOKUP against the current sheet.=SUM(ImportRange(“0Ak__Spreadsheet2__XaBC1LaDdSd1EzblQ1N3BBcWc”,”MONTHLY_SUMMARY”))=3*MIN(ImportRange(“0Ak__Spreadsheet2__XaBC1LaDdSd1EzblQ1N3BBcWc”,”MONTHLY_SUMMARY”))
NOTE: The “auto” update of data between spreadsheets when using the ImportRange function seems to be between a few seconds and about two minutes.
I hope this helps you get more use out of your Google Spreadsheets!
No idea of it. Thanks for invitation