thanks sauer for your time!!!

i know watersev it was kinda hard for me to explain what i was looking for. basically a 1-to-1 lookup reference from entry sheet to datatbl sheet. for every row in entry there should be a row in datatbl. that is easy, but the rows in datatbl have formulas and lookups that must adjust to the row references in entry sheet. Especially if, say, someone inserts a new row in the entry sheet.

sauer may have developed what I need....gonna go take a look after i drink some coffee and wake up a bit, but as was posted, if a forum master/guru takes a quick look and understands what it is i need and sees how sauer did it and thinks it may be even easier i am looking for as much help as possible.

Thanks for everyone's time!!!