Sort in ascending order

I have this macro running in 3 ranges, but this 3rd range will always have a product with amount of 0 on top, then the rest will follow order with the highest first????
Why is this 0 on top when it should be at the bottom, or with the other 0s when there is no data????

Yet I do not have a problem with the other two ranges?

Here is the code (3rd section down is the issue):

Please Login or Register  to view this content.

The ranges work as follows:
First column woul be a link (=) to the main sheet where products are inputted
the 2nd,3rd,4th columns are Vlookups, which looks at the first column and returns figures for what ever is in the first column. 5th column adds these totals up.
Macro should then sort this list in numerical order from the totals.

Any ideas guys??


Thanks

Hi, No I haven't when I created this, I was still learning, (still am) so didn't realise number formats would make a difference.
But I've just done a refresh, and the sames happened in the first range also.
But i'll try formatting anyway. Any particulat type of format for this?

I think its too large to upload, so i'll have to adjust the single sheet to work. I'll take a look in a bit and see what I can do.
Yes I never thought of it that way which would mess it up, it is formulas getting the results!

WK10.xls

The tab the list is on is (3D Overview) Theres a macro button which says "sort top 3" this will sort out the yellow sections to the right of this button.
The list populated for this starts on the same sheet at Z98.
All data populates from "costings" tab which it has to as I need other people to add in products from time to time and make the rest of the workbook work around being DUMB PROOF

The macro for this is in module 7.

Many sheets have been deleted so there will be alot of #REF on other pages as they have nothing to link too.
Also this will be used on all versions of excel, so the code would need to work for 2003 version.

You may die at the sight of some of the macro, but i'm learning still, Any pointers or any suggestions that you think would make this better would be welcomed (there's always an easier way to do something!!!)

Thanks very much

Ok thanks, yeah I forgot about the openworkbook macro, it opens a specific sheet depending on the time/day, but had to delete all but one to load the book within the size limit.
I'll take a look when I'm back on the PC tonight! I'll copy the module over and then the overview sheet, then I'll have to apply it to 3 other sheets which were deleted.
Thanks for your time, and I'll let you know how I get on!

Ok soooo there are now 2 columns with ALL products, but the macro basically copies and pastes the data as a value THEN sorts it....Which works!
BUT
What is the reason for it not working to begin with by using formulas?

Thanks very much!!!!!!!!

Strange how everything else went in order and the same one always stayed on top if there was no figure for it though.
I'll keep that trick in mind for future workbooks!!!!
Thanks for your help!

You are welcome!