LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.setup
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sorting data does not expand to other sheets ahkasiv Excel Worksheet Functions 3 September 28th 08 03:18 AM
Sorting data in protected sheets? Arsenio Oloroso Excel Discussion (Misc queries) 1 December 30th 06 08:54 PM
Sorting Data from 2 sheets, one sheet which is already sorted M. S. Excel Worksheet Functions 0 July 15th 05 06:42 PM
Linking sheets when sorting row and column data Sean 3DD Excel Worksheet Functions 0 January 5th 05 12:21 PM
Sorting Data to Different Sheets ccoverne Excel Worksheet Functions 1 November 10th 04 09:20 PM


All times are GMT +1. The time now is 01:12 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"