Help with Sort Marco

[mtndewgradon]

I have a sort macro that sorts a cells A through Q based on the values in Q. The problem I am having is I have a formula in the cells of column E that performs a caluclation based off whats in Column B. When the sort is performed the formula gets sorted with the names in column B but the formula is still referencing where the name was at before the sort. Basically if the name was in cell B12 and now is in B1 after the sort the formula in E1 points to B12 which has a different name it.

Here is the code for the macro. I am pretty much a noob when it comes to macro's. I have also attached the spreadsheet. Any help would be most appreciated

Please Login or Register  to view this content.

[tuongtu3]

Try this for now and wait for better code from experts:

Please Login or Register  to view this content.

Regards,
tt3

[mtndewgradon]

Thank you for the response. It didn't work. It shifted the data rows down and left 4 rows of blanks at the top. I may not of did the code correctly.

[tuongtu3]

Try the sample in attached and click a green button.

Regards,
tt3

[mtndewgradon]

That works great. Thank you.