View Single Post
  #1   Report Post  
Bazza Bazza is offline
Junior Member
 
Posts: 3
Default 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