View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Marcelo Marcelo is offline
external usenet poster
 
Posts: 1,047
Default 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.