Sorry after reading through other posts I feel i have not given my request enough detail. If someone could help me I would be very grateful, also I am not very familiar with Macros.
I have two sheets one called Expenditure which is the master sheet and one call Tput. I would like to automatically update the Tput sheet with rows copied from the expenditure sheets if the value in column L is "TP" both sheets would have the same heading rows. Oh and if possible once a row has been copied mark it as copied and only move new entries. I hope this is clearer and sorry to have put my request in twice.