Formula for Importing entire Column data between sheets - IMPORT RANGE?

[curlydog]

Hi,

Newbie here - In despair and my first post vanished into the ether.

I am creating a 2 sheet document to aid me learning Greek verbs and then export as a .csv in order to upload to make flash cards.

I need to import data from 2 columns in Sheet1 into Sheet2.

Sheet 1 has 6 columns of data into which I input verbs alphabetically and add to by inserting rows as and when. The 7th column contains a concatenating formula to combine present/past/future tenses of these verbs. I need to automatically import this column and the column containing the english meaning, into the second sheet. Then I can export.

I cannot find a way of doing this and am in total despair.
Can anyone help please?

thanks
cd

 

[jarjarbingie]

Hi,

Newbie here - In despair and my first post vanished into the ether.

I am creating a 2 sheet document to aid me learning Greek verbs and then export as a .csv in order to upload to make flash cards.

I need to import data from 2 columns in Sheet1 into Sheet2.

Sheet 1 has 6 columns of data into which I input verbs alphabetically and add to by inserting rows as and when. The 7th column contains a concatenating formula to combine present/past/future tenses of these verbs. I need to automatically import this column and the column containing the english meaning, into the second sheet. Then I can export.

I cannot find a way of doing this and am in total despair.
Can anyone help please?

thanks
cd

a sample would help..

 

[curlydog]

I'm sorry but I don't know how to attach something here.

All I want to do is to copy two columns from sheet one to a different sheet - automatically. So when I insert new rows in sheet 1, it also does it in sheet 2.
It sounds like it should be an easy thing to do.

I'm using a mac, running Excel 2011.

I have found a way of achieving what I want but it is not on excel. It is the IMPORTRANGE feature on Google sheets. Is there no way of doing this in Excel?

Thanks

 

[jarjarbingie]

I'm sorry but I don't know how to attach something here.

All I want to do is to copy two columns from sheet one to a different sheet - automatically. So when I insert new rows in sheet 1, it also does it in sheet 2.
It sounds like it should be an easy thing to do.

I'm using a mac, running Excel 2011.

I have found a way of achieving what I want but it is not on excel. It is the IMPORTRANGE feature on Google sheets. Is there no way of doing this in Excel?

Thanks

say you want to pull column C from Sheet1:

A2 = OFFSET(Sheet1!$C$1,ROW()-1,0)

 

[curlydog]

say you want to pull column C from Sheet1:

A2 = OFFSET(Sheet1!$C$1,ROW()-1,0)

I've probably done something wrong but this just gives me a 0. Should I put anything in the brackets after ROW?

This seems like a very common thing to want to do to merely duplicate the contents of an entire row into another sheet and for it to be capable of re-adjusting if you add another row. How odd that it is not an easy thing.

Thanks
cd

 

[curlydog]

I've probably done something wrong but this just gives me a 0. Should I put anything in the brackets after ROW?

This seems like a very common thing to want to do to merely duplicate the contents of an entire row into another sheet and for it to be capable of re-adjusting if you add another row. How odd that it is not an easy thing.

Thanks
cd

Correction - this does work - I was just writing Sheet1 instead of the sheet name. Also I see I have to copy this formula down to all cells too. It updates if I add a new row too, which is what I needed it to do. I just don't understand the function OFFSET tho or why this works.

This was the formula in Google docs
<bdo dir="ltr">=importrange("**","Verbs!A2:A500")

where ** is the identifier of the sheet on google drive. You only put this in the first cell and it does the rest.

Thanks for you help. I wish I knew how this formula of yours worked.

Best
cd</bdo>