sorting two tabs together

[etprash]

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

 

[SkipVought]

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]
When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large[/sub]

 

[etprash]

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.

 

[SkipVought]

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]
When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large[/sub]

 

[macropod]

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]