Help with sort out only numbers and copy to next sheet

Hi All,
*
Firstly let me thanks to the admin and all the members for
their wonderful job which they are contributing in this great forum. I have
learnt a lot from all of you.

Please see below specific points for what I have and what I need, apologies in advance if I this is not very clear

I am stucked with up a sheet which have a data and I want some specific columns to be copied to be a workbook where I run this macro.. I am attaching the workbook .. so u will be more clear.. ssss.xlsx

hi vpnvipin, i didnt see the sorting part. but this might be something you can use:

Please Login or Register  to view this content.

@benishiryo

I folow this tread to learn of it myself.

I get an failure (yellow mark) with this line.

It is the line which will copies the amounts.

I'm using Excel 2007.

Please Login or Register  to view this content.

I don't see what had to be changed.

Thanks for the PM.

Here is my workbook.

It gives the message
failure 13, type don't match (in dutch)

Can the issue be, that there is a . (dot) in the amount instead of a , (komma) which is normaly in my Dutch version?

@oeldere. i tried to run your file & it worked indeed. so i tried to change my control panel settings to Dutch (Netherlands) formatting. it had the same error message as yours. i'm really not familiar with such settings issues but i discovered something; the reason why i had to add "0" to the codes is because in sheet "jam", column S, U & W are texts. what seems weird is that the Dutch settings recognised only column S as text. you should be able to see the green triangles on the top left of the cells for column S. those can help you convert to numbers. but this is not existent in column U & W. if i changed it to:
12.00
and
5.56
it works. so i dont think it's the dot & comma problem. or if you remove the "+ 0" from my codes, it would also work but not convert them to numbers. sorry, this is all i could find out.

@benishiryo

Please Login or Register  to view this content.

Please don't apologize, you did a tremendous job.

Please Login or Register  to view this content.

I have (earlier) found code to convert text to numbers I could use to solve that problem.

Thanks again, for this clear explaination.

I'm realy glad with it.