LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Find value in array Brook6 Excel Worksheet Functions 26 January 30th 07 09:40 PM
Locked formula within a named Database Ross Excel Discussion (Misc queries) 0 September 13th 06 12:21 AM
Database Formula Ross Excel Discussion (Misc queries) 4 September 10th 06 11:30 PM
Dynamic Range with unused formula messing up x axis on dynamic graph [email protected] Charts and Charting in Excel 2 February 2nd 06 08:02 PM
DATABASE FORMULA becky Excel Discussion (Misc queries) 1 January 20th 05 01:45 AM


All times are GMT +1. The time now is 07:11 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"