Help with database formula.
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
|