I will reword my previous question because after looking at it I think I worded it incorrectly.
I have a database that collects customers surnames, middle names, address, towns, etc. So if we take the first entry under surnames I have the T formula which refers to the cell and column where the info is, eg: =T('Shop Invoice'!D29) the next cell down, again under surname has =T('Shop Invoice'!D87).
What I need to know is what do I have to add to the second formula so that I can autofill each successive cell to look at the next cell of information 58 cells down from the previous one.
Any help would be greatly appreciated, Thanks

Bazza

=T(INDIRECT("'Shop Invoice'!D"&29+(ROW(A1)-1)*58))

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Bazza" wrote in message
...

I will reword my previous question because after looking at it I think I
worded it incorrectly.
I have a database that collects customers surnames, middle names,
address, towns, etc. So if we take the first entry under surnames I
have the T formula which refers to the cell and column where the info
is, eg: =T('Shop Invoice'!D29) the next cell down, again under surname
has =T('Shop Invoice'!D87).
What I need to know is what do I have to add to the second formula so
that I can autofill each successive cell to look at the next cell of
information 58 cells down from the previous one.
Any help would be greatly appreciated, Thanks

Bazza




--
Bazza