Sort to another tab

[jdengel]

A B C D E
F G H I J
K L

TRX Date (Formatted) Time (Formatted) Employee Name Vehicle # Site
Name Site Address Site City Product Code Product Description Qty Amount
Odometer #
6/1/2004 10:50 AM SMITH, JOHN P028 7-ELEVEN 123 WILDWOOD ROAD
GIBSONIA 2 Unleaded 30.863 59.16 138162
6/1/2004 3:37 PM DAVIS, JOHN G011 GET GO 1 ROUTE 2222 DELMONT 2
Unleaded 28.517 54.67 41303
6/1/2004 3:44 PM DOE, ANDRE P037 BROS EXXON 101 THIRD AVENUE ROBINSON
TWP 2 Unleaded 23.548 45.14 26074
6/1/2004 6:45 PM READING, JODY G041 7-ELEVEN RTE 88
INDIANA 2 Unleaded 9.657 18.52 5541




I transposed these 12 columns from a larger spread sheet, this is all the
info that I needed.
Now I need to copy this info to another sheet and sort at the same time.
Sort by C then A then B
I need a formula to that automatically

Can any one help out with this...thanks in advanced

If it would help email me and I can attach a copy of the file to show ya
what I have done so far and what I want to do...
in the end I want I want to end up with each employees total mileage fuel
used and avg mpg and maybe a couple other things.

JD

 

[Earl Kiosterud]

J,

You don't say why you want the data moved to another sheet. Doing so
requires either links from that sheet to the one containing the data, or a
macro to copy it. Then you'd sort it after that. It's better to not make
copies of data if you can avoid it. And it's better to keep like data in
one sheet. For more on that, read "Data across multiple sheets" at
www.smokeylake.com/excel.

 

[EARTHWALKER]

Earl, why do you always reply back in triplicate

 

[jdengel]

the first sheet will change weekley then all the sheets from there will auto
fill and the sheet i am working on now will
copy sheet 3 the info that i need then i want sheet 3 to copy sheet 2 and
auto sort by colum b then a then c then sheet 4 will take info from that
sheet and total fuel per person and ect...
does that help./
thanks
JD

 

[Earl Kiosterud]

Earth,

Interesting. There are indeed three replies. I only repied once. I don't
see it in triplicate here. I use Outlook Express, connected directly to
msnews.microsoft.com, the host of the Excel newsgroups. Do you always see
three with my posts? Any one else's? I wonder if this is another
ExcelForum glitch.