Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

sorting two tabs together

Status
Not open for further replies.

etprash

MIS
Nov 19, 2007
13
US
Hi friends,
I have an excel file with data in two worksheets (identical data).
Total number of rows exceeds 72k.
I want to sort this data on one of the columns in one go.

If anyone has solution/thoughts, pls do share.
Regards,
Prashant
 



Hi,

Put the data in one table on one sheet.

There is rarely that source data should be chopped up. You would be miles ahead to have all your data in one sheet. This is how Excel is designed to function, as demonstrated so vividly, by your dilema.

Skip,
[sub]
[glasses] When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large[tongue][/sub]
 
Thx for reply. But I have 72K data. So they can't be put in one worksheet ( excel's limit being 65k).
or am i missing s'th from your reply.

 




1. I'd probably use MS Access for this table of 72K rows.

2. If you insist on Excel,
sort both tables separately
determine where they can be split to get, for instance,
A-L on one sheet and M-Z on the other.

Skip,
[sub]
[glasses] When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large[tongue][/sub]
 
Hi etprash,

Excel can't sort data that are spread across multiple worksheets.

Excel 2007 can handle 72K of data rows quite easily. For earlier versions, a vba solution is required.

Cheers

[MS MVP - Word]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top