I have a large table of data, what I would like is a macro that when you run it, it pulls specific data from that large table and pastes it onto a seperate worksheet. The column which i am concentrating on using is Cost. The total cost should be a set amount for example £100, so what i would like is every row which has more or less than £100 in the cost column to be pasted into a table of its own on a seperate worksheet.

Apreciate any help on this, many thanks!!!!