How to use data fron one sheet to print forms created in another sheet 
Author Message
 How to use data fron one sheet to print forms created in another sheet

I have a sheet with a number of rows of data consisting of several
columns of fields. EX: first name, last, school, etc.

I have created 3 forms in 3 other sheets that I want to print with the
data from the data sheet.

How do I get Excel (V. 2000) to use the data and print each form with
the different student data?

I am familiar with Excel but I am a rank novice with Macros, any help
will be greatly appreciated.

Bob



Fri, 22 Jul 2005 04:07:41 GMT  
 How to use data fron one sheet to print forms created in another sheet
You would either need to have a place where you manually enter a unique
student identifier and the remainder of the form is populated using formulas
that key off the value in that field  (such as Vlookup, Match, Index, and
that ilk).  You could select this identifier from a dropdown built with
data=.validation.

However, this would require making the selection and printing, making the
selection and printing, etc.

To automate it, you would need a macro that loops through the list of names
and populates the unique identifier film with the sheet(s) set up as above,
then print, then put in the next identifier and so forth.   Or the macro
could also populate the fields and they would not need to have formulas.

To loop through a range of cell

Sub MacroPrint
  dim cell as Range, rng as Range
set rng = Worksheets("Form1").Range("A1")  ' identifier cell
set rng1 = Worksehets("Form2").Range("A1") ' identifier cell
set rng3 = Worksheets("Form3").Range("A1") ' identifier cell
With worksheets("Data")
   for each cell in .Range(A2:A50")
      rng.Value = Cell.Value
      rng1.Value = cell.Value
      rng2.Value = cell.Value
      worksheets(Array("Form1","Form2","Form3")).Printout
   Next
End With

End Sub

Regards,
Tom Ogilvy


Quote:
> I have a sheet with a number of rows of data consisting of several
> columns of fields. EX: first name, last, school, etc.

> I have created 3 forms in 3 other sheets that I want to print with the
> data from the data sheet.

> How do I get Excel (V. 2000) to use the data and print each form with
> the different student data?

> I am familiar with Excel but I am a rank novice with Macros, any help
> will be greatly appreciated.

> Bob



Fri, 22 Jul 2005 06:11:22 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. automaticly copying data from one sheet into another sheet using VBA

2. using data from one sheet to populate multiple sheets

3. Creating a separate sheet from each row in one sheet

4. Inserting data on one sheet from another sheet

5. HELP! Summarize sheet data on one sheet

6. formulas on one sheet affecting data on other sheets

7. Printing non-contiguous sheet ranges on a one sheet printout

8. printing template sheet with data from other sheet

9. Copying data from one sheets to the other using Vba

10. vba using find to copy data from one sheet to another- Please Help


 
Powered by phpBB® Forum Software © phpBB Group