What's the best way to do this?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mattgoof2005 - 06 Jun 2006 23:40 GMT

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?

Reply to this Message

Gary''s Student - 07 Jun 2006 00:23 GMT

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.

Signature

Gary's Student

> 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?

Reply to this Message

SITCFanTN - 11 Jun 2006 23:51 GMT

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

> Consider using Autofilter.
>
[quoted text clipped - 5 lines]
> > departments. What's the best way to transfer all that data to the forms and
> > print off one for each deparmtment?

Reply to this Message