Filter Copy and paste data in using VBA based on a criteria

[Eustace07]

Hi All

I have a transaction data which currently undergoes tedious manual filtering and cleaning before I use it for MI. I want to keep the raw data in a different sheet(Transactions-Data) and from there I want copy and paste it into a new sheet(Transactions) using VBA. As Part of the copying I want to the macro filter out unwanted rows based on criteria(highlighted in the attached). I've got a vba macro however I need help to tweak it to accommodate the criteria. Grateful if anyone can help me win this one. Thanks

[TMS]

This will filter the data and copy it to the Transactions sheet. Once it's there, you can loop through the columns and delete any blank columns.

Please Login or Register  to view this content.

[Eustace07]

TMS you've sorted me out big time!! Much appreciated. This exactly what I want. Bless you.

[TMS]

You're welcome. Thanks for the rep.

[Eustace07]

Hi TMS, Please is it possible to tweak the code to copy over just selected columns like say Columns A:B, D:C, F, I, V, & AE? I was tiding up the rec and realised I don't need a whole lot of data. Thanks

[TMS]

From a practical point of view, it's easier just to copy everything across and then delete columns, starting from the Right hand side.