I have no idea how to suck data from one spreadsheet to another in Google Docs, but I can make a suggestion on the permissions issue.
If you suspect that permissions might be the problem, try exporting the Google Docs out as Excel or OpenOffice files, then delete the Google Docs, then import the files previously exported. Since you (just one person) are importing those files, it will assign brand new permissions to them. Chris On Thu, Jan 26, 2012 at 9:29 AM, Jack Coats <[email protected]> wrote: > Yes, I need one... This trick is to suck data from one > spreadsheet/workbook onto a single sheet from another workbook/file. > Both are in Google Docs. Owned by the same userID. After it not > working and the GDocs Helps saying that it could be a > permissions problem, I even shared the source spreadsheet to myself, > and still no joy. > > Problem Details. > > I have two spreadsheets in Google Docs (separate spreadsheet files, in > same Google Docs account). > > One is where I keep detail, and summarize to one sheet in the workbook > (or file). This workbook is called "Log Shed Expenses". > > I have a second spreadsheet where I want to keep details about the > info in the other workbooks/spreadsheets. > > In the second spreadsheet, in a cell (b2) I enter > > =ImportRange("Log Shed Expenses","Spent!J1:J1") > > It is supposed to pick up the one number from the one cell on the other > sheet. > > In cell b1 I entered > > =max(ImportRange("Log Shed Expenses","Spent!A1:A100")) > > and it isn't working either. The second is a date (I want the most > recent date entered). > > > I have tried making the whole thing with no spaces in names, changing > capitalization, all the stupid little things I could come > up with that I normally stub my toe on. Still, no joy. > > It has been some time ago but I did this kind of thing 'all the time' > with M$ Excel in a former life. > > If someone has some hints, input is appreciated. > > ... Jack > > -- > You received this message because you are subscribed to the Google Groups > "NLUG" group. > To post to this group, send email to [email protected] > To unsubscribe from this group, send email to > [email protected] > For more options, visit this group at > http://groups.google.com/group/nlug-talk?hl=en > -- You received this message because you are subscribed to the Google Groups "NLUG" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/nlug-talk?hl=en
