Sort button ...not working

Hello

Having some issue with my sort buttons.

I created extra rows, but all of a sudden, the sort button (macro) is not functioning at all.

can someone pls advise! been staring at my screen for well over 2hrs now! thx you

pls see attached workbook.

Your sort macro is doing exactly what it's supposed to do. However, you can sort until the cows come home but the formulas in column C will always refer to the corresponding rows in sheet Data. In fact, these formulas use a technique that is often used to defeat such sorting, as well as being impervious to row insertions and deletions. At a quick glance it appears that the other columns are derived based on what is in column C. Therefore any sort will have no effect.

I suggest you change your macros to sort the Data sheet instead of Royal Rankings Data. For example,

Please Login or Register  to view this content.

hello

thx you so much. i didnt realize my formula was being factored into the macro. nonetheless, after implementing your concept, its giving me an error :S

Please Login or Register  to view this content.

any suggestions?

the error is:

the sort reference is not valid. make sure its w/in the data you want to sort, and the first sort by box isnt the same or blank.

Your post does not comply with Rule 8 of our Forum RULES. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser)to the cross-post. Expect cross-posts without a link to be closed a message will be posted by the moderator explaining why. We are here to help so help us help you!

Read this to understand why we ask you to do this, then please add links to your crossposts.

hello my apologies.

i usually tickmark solved or vice versa, but will make sure it does not occur again; thx u

http://www.mrexcel.com/forum/showthr...=1#post2789532

Please read my post again and then comply with my request.