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 |
All times are GMT +1. The time now is 04:57 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com