Create a new sheet using data in one column copying data

[Closed]
Report
Posts
3
Registration date
Thursday November 27, 2014
Status
Member
Last seen
November 28, 2014
-
Does any one know how to create a macro which takes the following data:

A B C D
1 Rabbit Carrot 12345.67 5436.98
2 Horse Hay 456.39 234.98
3 Tiger Lamb 29876.70 908765.0
4 Snake Mouse 345.97 12345.0
5 Snake Bird 1 2

and then creates sheets in the same spreadsheet called: "rabbit", "horse", "tiger", "snake" and copies all data for that sheet. So "Rabbit", "Horse" and "Tiger" will have one record consisting of column A-D and "Snake" two.

Ideally I would like to add colums E (difference between C and D) and F (percentage difference between C and D) in the new sheets as well....!