Create a new sheet using data in one column copying data

Closed
LEJN Posts 3 Registration date Thursday November 27, 2014 Status Member Last seen November 28, 2014 - Nov 27, 2014 at 09:20 AM
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....!