I have a table with lots of data( department number, name, manager, etc.) I
also have a data-request form I want to print off for all of those
departments. What's the best way to transfer all that data to the forms and
print off one for each deparmtment?

Consider using Autofilter.

You can filter to display only a single department's data, copy it to the
form and print. Then repeat with the next department.
--
Gary's Student


"mattgoof2005" wrote:

I have a table with lots of data( department number, name, manager, etc.) I
also have a data-request form I want to print off for all of those
departments. What's the best way to transfer all that data to the forms and
print off one for each deparmtment?

I have this same situation, I download a report every day and just want to
copy and paste sections of the report to new sheets. I want to do this with
code, is that even possible? I've been working on this all day with no luck.
Thanks

"Gary''s Student" wrote:

Consider using Autofilter.

You can filter to display only a single department's data, copy it to the
form and print. Then repeat with the next department.
--
Gary's Student


"mattgoof2005" wrote:

I have a table with lots of data( department number, name, manager, etc.) I
also have a data-request form I want to print off for all of those
departments. What's the best way to transfer all that data to the forms and
print off one for each deparmtment?