View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.setup
A. Beare A. Beare is offline
external usenet poster
 
Posts: 1
Default Sorting data on two sheets

I have data that occupies some 400 columns. Because Excel has only 256
columns, part of it goes on a second sheet. Sorting data on sheet # 1
re-arranges the rows on sheet one but not on sheet 2. SO. . .
1) Is there any way to increase the number of columns in a worksheet (I
certainly do not neeed 6000+ rows !)?
2) Is there any way to make a sort on sheet 1 also re-order the rows on
sheet 2?
--
A. Beare