Re: Creating a manifest from sorted data

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Dave Peterson (ec35720_at_msn.com)
Date: 03/02/04 

Date: Tue, 02 Mar 2004 17:11:33 -0600

I think you'd need some VBA to make this work (almost) unattended.

But it wouldn't take too long to do it manually, either.

Apply Data|Filter|Autofilter to your input data.
Filter the consignment column to show only those codes you want.
Highlight that visible range
copy it
paste it into the formatted document (if it's the same format???)
(In fact, if it has the same layout, you might want to do:
Edit|paste special|values to keep the existing format.)

Then print that *** (twice?).

Then I'm kind of lost on what to do next, but this might give you a head start.

RLE Computers wrote:
>
> Hello all
>
> I'm trying to create a report using data input for tracking parts returns, I
> can select the data I need by auto searching on a cloumn called
> "consignment" which is a unique code. I want to export all the data from the
> sort to a separate work*** which is a formatted document to use as my
> tracking manifest ***. I would like to have this print two copies and then
> auto select another work*** called "Freight Return Address" with the
> option to select number of copies to be printed.
> Is this possible without writing a once off program to achieve.
>
> Thank you for reading and any feedback.
>
> Regards
> Ray 

-- 
Dave Peterson
ec35720@msn.com
Quantcast