Macro to pull specific data out and place in a seperate worksheet

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!!!!

I think perhaps you should attach a small sample of your data.

Im afraid i cannot attach the table, as it contains private/confidential data. Heres a table ive just made from scratch, which might be able to help you, as you can see the Cost column. So i would like every row which does not have £20 as the cost to be copy/pasted onto another worksheet as a seperate table.

Any column that has more or less than £100? Do you mean any row that isn't specifically £100?

Do you have a specific worksheet in mind or do you want it to just create a new one?

Please Login or Register  to view this content.

I am having a problem with the macro above, it gives me an error message - Compile error. Expected End With

Any suggestions please?!?