0

So I need to find the formula to pull a column out of one page of my Google Docs spreadsheet and insert it into a separate workbook.

Here are some more details: all rows from column C (part number) from sheet 2, workbook 1 and insert it into sheet 1 of workbook 2 (under column C "part number").

Improve this question
0

1 Answer 1

Reset to default
0

This Formula gives you the perfect solution:

=ImportRange("0Anrm0HgYyzzRdGR3TWpBelFCenJYM01ZUDZsaWNsTkE";"Sheet2!C3:C13")

Write this formula in the "C3" of your "workbook 2,sheet 1".

Improve this answer
2
  • funny, because I deff tried to work that formula ... Iguess there was something that I missed. Thanks for your help!
    – WinterWierdo
    Dec 14, 2013 at 20:35
  • hey @karthik I have another question if you have the time. Here is the link for its posting
    – WinterWierdo
    Dec 14, 2013 at 22:40

Not the answer you're looking for? Browse other questions tagged or ask your own question.