Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Worksheet formating question
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Worksheet formating question
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: 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Worksheet formating question
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I get ONLY new info from 1 Worksheet to another automatical | Excel Worksheet Functions | |||
Excel worksheet functions question. | Excel Worksheet Functions | |||
Copy worksheet and keep all formating | Excel Discussion (Misc queries) | |||
Conditional Formating Extreme Question | Excel Worksheet Functions | |||
Question about sorting in protected worksheet | Excel Worksheet Functions |