Fill Series Across Multiple Workbooks

[DangerMouse]

Hi all,

Am attempting to reference data from one workbook to another, whilst
this is straightforward in itself I would like to be able to "fill"
across in a series fashion i.e. incrementing the columb letter
everytime. Is this possible? Doing it mannually is becoming very
tedious!!

Any help would be great.

Thanks

 

[Roger Govier]

Hi

If you have in column B of Sheet2 a formula like
=Sheet1!B1
as you drag the formula across the page with the fill handle, then it
would automatically increment to
=Sheet1!C1, Sheet1!D1 etc. as you move across

The fill handle is the small black cross that appears when you hover
over the bottom right corner of the cell.

If this is not incrementing for you, it means that your cell reference
is fixed instead of relative.
e.g. $B$1 would not increment as you go across columns, B$1 would
equally, B$1 would not increment to B$2 as you go down the column, but
B1 would increment to B2, B3 etc.

Hope this helps

Regards

Roger Govier

 

[DangerMouse]

Thanks for the reply that wasnt exactly what i was looking for however.

I am looking to fill series from an external workbook.

Any ideas?

thank

 

[Roger Govier]

Hi

Do you mean something like
=VLOOKUP(A1,Sheet2!$A$!:$G$1000,2,0)
where you are wanting to increment the 2 in the above to take successive
columns from the lookup table?

If so, replace the 2 with Column(), which will increment with the column
number as you drag across.

In B1 =VLOOKUP(A1,Sheet2!$A$!:$G$1000,Column(),0) would be exactly the
same as B is column 2.
You can always do + or - a number after the column() variable if required.

If it is not this, then please pot back with more information about what
you are trying to achieve.

Regards

Roger Govier