View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
OHNESORGE OHNESORGE is offline
external usenet poster
 
Posts: 12
Default Sorting a worksheet with multiple columns

my worksheet has 3 columns in which i need to have the option of sorting at
any time, i would like to take a random empty cell and use it as a switch
button so to say, to sort A,B,C . Taking in mind that there are 100 Rows

A1=Company Name
B1=Part Number
C1=Part Number

D1=Start Date
E1-O1=Dates of job steps
P1=Completion Date

I need to sort and not loose any cell structure at the same time