I am attempting to set the values of one column from one document to the column of another document. This is what I have so far:
tell the application "Numbers" tell the table "Table 1" of the sheet "Sheet 1" of the document "LockeWallace" set theData to the value of the cell of column "B" set theCount to the count of rows end tell set theFile to "MSPS:Assessments:Scoring:Locke-Wallace.numbers" tell the table "data" of the sheet "Locke-Wallace" of the document "Locke-Wallace.numbers" set theRange to cells 1 thru theCount of column "B" repeat with x in theData repeat with y in theRange set the value of cell y to (x as string) end repeat end repeat end tell end tell
I keep playing with it but cannot get it to go. The current configuration gets;
The problem seems to be that the variable y is presented as a text (ie in “y”)
I have spent a lot of time on this and cannot see what I am missing.
Browser: Safari 531.21.10
Operating System: Mac OS X (10.6)