Worksheet formating question

S

Stacy O

I have a workbook with tabs a, b, and c containing all my information.
Following those tabs, there are 50 more tabs with the exact same form. These
forms pull all their information from a, b, and c. Is there an easy way to
link the 50 forms (tabs) to the information in tabs a, b, and c without
having to do each form, one at a time. Form 1 will equal line one in workbook
a, b, and c. Form 2 will equal information in line two of a, b, and c
basically.

I hope this makes sense. Thanks for the help.
 
M

Marcelo

hi, take a look on the help regarding address function and indirect function,
using it embeded you will have a good result
hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Stacy O" escreveu:
 
C

CaptainQuattro

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)
 
Top