copy 1 column from another spreadsheet

[GRS]

I have a three files that i export to regularly, the columns and title
are always exactly the same but the actual data in them changes eac
time I export. The number of records exported is also different i
each export.

I want to set up a master spreadsheet that brings in data fro
different columns from all three of the other spreadsheets.

So for example, in the Master spreadsheet I want:

cell A1 to give the data from Exportsheet1 cell J2,
cell A2 to give me data from Exportsheet1 cell J3,
cell A3 to give me data from Exportsheet1 cell J4

until i reach the end of the rows. I can delete any rows that bring i
empty data.

The way I'm current doing it is to press = in the masterspreadsheet (i
cell A1 for example) and then move to the Exportsheet1 cell J2 and pres
enter.

This obviously works but I'd like to copy and paste a range rather tha
doing each cell individually as I have lots of cells in this spreadshee
and other spreadsheets to do this to.

I've tried copying the forumula but it isn't copying it relatively.
I'm only going to have to set this up once as the masterspreadshee
won't change - it will just update everytime i open it with the ne
data from the exported files.

Sorry if this is rambling, I've tried to give enough information a
poss.

Thanks

Gil

 

[Frank Kabel]

Hi
in A1 enter
='Exportsheet1'!J2

and if you copy this down the cell reference should change

 

[GRS]

thanks Frank, that's exactly what i needed