Thread: Sorting
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
reedsm reedsm is offline
external usenet poster
 
Posts: 1
Default Sorting

I have a detailed worksheet that has multiple columns.It looks like below
with the figures filled in under each heading. These represent columns a-f.
Then in column g and h I have some totals.Columns I-M pull the codes and
amounts from columns a-f and total them. I am trying to sort a selected range
a-f without effecting the other column data. Everytime I select a-f only and
try to sort it grabs the other coulmns as well and scrambles their data. But
I am able to sort I-M only and sort and that works fine. Any suggestions?

Order Dt Code Company Item Cleared Amt Encumbered Amt