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