Creating a manifest from sorted data

  • Thread starter Thread starter RLE Computers
  • Start date Start date
R

RLE Computers

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 worksheet which is a formatted document to use as my
tracking manifest sheet. I would like to have this print two copies and then
auto select another worksheet 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
 
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 sheet (twice?).

Then I'm kind of lost on what to do next, but this might give you a head start.
 
Hi Dave
Thanks for the reply, basically that is what I'm currently doing but I want
to automate it to eliminate possible tranposition errors.
What I'm trying to do is when the data is sorted it automatically moves that
data to a new worksheet / workbook called manifest - I want the data to be
placed, starting at a particular cell. I can then print a copy of this
manifest worksheet.
Is their anyway of achieving this without programming or if programming
needed can you point me in the general direction.

kind regards
Ray
 
Debra Dalgleish has some sample workbooks that move information to other sheets
using data|filter|advanced filter. They're at:

http://www.contextures.com/excelfiles.html#Filter

But without knowing more about your data, the only advice I could say is to try
to do it manually a few times (if you haven't already). Then maybe record a
macro when you do it once for real.

Sorry.
 
Hello Dave
Thanks for the link I should be able to work something out from one of the
examples - I've tried a macro but with no success because I'm selecting
different data every time.
Kind regards
Ray
 
Back
Top