Pulling column from sheet 2 and importing into another workbook

Question

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").

score 0 · Accepted Answer · edited Dec 14 '13 at 10:02

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".

edited Dec 14 '13 at 10:02

Alex

22,820
12
83
106

answered Dec 14 '13 at 08:09

Karthik VU

201
1
3

Pulling column from sheet 2 and importing into another workbook

1 Answers1