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.


2 comments:

  1. So does that mean that you cannot import back from "B" to "A" but need to create another spreadsheet to get the data from spreadsheet "A"?

    ReplyDelete
  2. Hi Ian:

    You can import data from spreadsheet B into spreadsheet A ... but not in the same cells which were imported into spreadsheet B from spreadsheet A ... that will be akin to circular referencing -- into any other cells you can of course. Sounds confusing ... I know.

    Cheers!
    Yogi

    ReplyDelete