If I understand your situation properly, a better way to achieve you
result would be to create a single form that picks up different rows of
your data depending on the record number that you input.
As a simple example
Sheet1
Row 1 Contains headings:
A1 = NAME
B1 = AGE
B2 = PHONE
A2 = JOHN SMITH
B2 = 30
C2 = 555-5555
A3 = JANET JONES
B3 = 28
C3 = 444-4444
Sheet2
Cell A1 = Record #:
Cell B1 = 1
Cell A2 = Name:
Cell A3 = Age:
Cell A4 = Phone:
Cell B2 = =OFFSET(Sheet1!$A$1,$B$1,0)
Cell B3 = =OFFSET(Sheet1!$A$1,$B$1,1)
Cell B4 = =OFFSET(Sheet1!$A$1,$B$1,2)
--
CaptainQuattro
------------------------------------------------------------------------
CaptainQuattro's Profile:
http://www.excelforum.com/member.php...o&userid=32763
View this thread:
http://www.excelforum.com/showthread...hreadid=572396