What's the best way to do this?

M

mattgoof2005

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

Gary''s Student

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.
 
S

SITCFanTN

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Grouping Names in Mail Merge 0
Is there a non-macro way to do this? 3
Auto-Fill From Table 1
Space at end of multi page list to accommodate new entries 1
Embed the same Excel multiple times 0
Page numbering with Merged Document and IF statements 1
Consolidation Table from Different Excel Tabs with Different Format 1
Excel does not accept text format! 0

Top