All you wise and mighty Excel gurus... I have the attached
spreadsheet. I
will be scanning in the values (via a barcode scanner) into column A.
What
I then need is a macro that will leave the Column A values in the
order
that they appear, but then sort columns B,C and D to match the value
in
Column C to that of Column A. The number of rows may vary, so it would
be
nice to have something that an amateur like myself could modify (or
that
would work with any number of rows).
Thanks in advance!

Here is a visual example and the actual data (see the different
worksheet tabs)

www.progressivetel.com/~radney4/Scan.xls