Sorting merged tabs

[sqledge]

Hi ,

I have a problem where the i have to sort merged tabs based on one value.I could not explain it clearly so I am attaching an excel sheet that has the example.Here I have to sort the country tabs on the left based on the transaction amounts.I am a newbie.so i am having hardtime finding a way to fix this.Any help would be highly appreciated.

Thanks

[sqledge]

Hi ,

I have a problem where the i have to sort merged tabs based on one value.I could not explain it clearly so I am attaching an excel sheet that has the example.Here I have to sort the country tabs on the left based on the transaction amounts.I am a newbie.so i am having hardtime finding a way to fix this.Any help would be highly appreciated.

Thanks

The country tabs should be placed or the text in those tabs should be replaced in the descending order of the transaction amounts.

[MarvinP]

Hi sqledge

The format of your data does not lead itself to be easily manipulated by Excel. See the attached where a beter way of keeping your data is shown along with a graph that can be easily constructed.

Read a few articles on Excel Tables to see what I mean, like:
http://www.jkp-ads.com/articles/Excel2007Tables.asp

[sqledge]

Hi sqledge

The format of your data does not lead itself to be easily manipulated by Excel. See the attached where a beter way of keeping your data is shown along with a graph that can be easily constructed.

Read a few articles on Excel Tables to see what I mean, like:
http://www.jkp-ads.com/articles/Excel2007Tables.asp

Thanks marvin for the suggestion.