excel 2004 column sorting

[li4fan2]

Version: 2004 Operating System: Mac OS X 10.4 (Tiger) Processor: Intel I've read up a bit on others' sorting issues, but haven't come across exactly the same problem as mine. I used to be able to sort the info in one column and the corresponding info in the other columns would sort along with whichever column I chose at the first. Now, my corresponding columns don't sort along with my first sort, resulting in inaccurate info. Also, the workbook I am working with contains macros; the workbook contained macros when I first began using using it, i.e. when sorting was no prob. I did attempt to add a macro to this workbook recently, which may or may not have been when my sorting problems began.

thanks for any guidance/suggestions,
li4fan2