Tuesday, October 18, 2011

yogi_Import Data That Itself Had been Imported To Verify That The Integrity Of The Imported Data Is Maintained

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                            www.energyefficientbuild.com
iantrapl said:
Can import data from the document "A" ....=IMPORTRANGE("0Au0oXAiis3xidEQ4akxUdHJMQk1RdmxlSW9XTExRZ2c","sheet1!b29") to document "B" but when I try to use the importrange function to get the data from "B" to "A" then the process fails even though both documents have the same public authority. Retrieived the Key for "B" document and using the same info for the sheet and location.
user can not import into Sheet1!B29:B40 of spreadsheet A from spreadsheet B which was used to import the same range of data from spreadsheet A ... I know it sounds confusing but it is akin to circular referencing.
What I present in the following is to show that one can use ImportRange to import a range Sheet1!B29:B40 from spreadsheet A into cell B28 of spreadsheet B as the user had done -- then I import the data in cells Sheet1!B28:B39 of spreadsheet B (which was imported from cells Sheet1!B29:B40 of spreadsheet A) into Sheet1!A1:A12 of spreadsheet C that the integrity of the data has been maintained.