Macro to sort data,match and paste in to relevant sheets on same workbook

Hi All,
Thanks for reading my Thread,I'm new here and need some help on excel,
I get a Data on a daily basis at work, at present i sort them out manually and paste them on to sheet1 - sheet2 -sheet3 and so on, i have large number of data Appx: 12000 row, I want to set up a macro or formula,that excel can sort the data match it and copy, paste it on to other sheet in same workbook. ie,

A B C D
12 Expense Turkey New =====> Sheet Name Turkey
25 Expense Turkey New =====> Sheet Name Turkey
45 Invoice France Workflow ======> Sheet Name France
55 Invoice France Workflow ======> Sheet Name France

I would really appraciate if someone could help me about this

I also attached sample file ,which you can work on

Many thanks for your kind help and look forward to receive your support on this

Benjamin

This is also my problems 3-4 weeks ago.See solution by Dave.
Do they have the same output?

http://www.excelforum.com/excel-prog...ml#post2208638

Hi Smalltime,
Many thanks for the response, i have now good idea how to work around on mine.as it was bugging me for whole week :-))))

Have a nice day....

Kind regards

Benjamin

I'm better at VBA than functions so my go at it would be to do something like this:

-Save a macro-enabled version of your file or macro-enable your existing file
-Create a Form Button "Sort" on worksheet1
-Put the following code in a new module in the visual basic editor
-Assign the Sort Button macro to "Sort_Click"

I attached a working macro-enabled worksheet of your example.

Please Login or Register  to view this content.

I didn't hunt down all the variables and put the clean up in there - but this would be a good idea.

I hope this helps.

Many thanks chrns12 , this is perfect .