Macro to move rows from one tab to another

Hi everyone.
I have been asked to look at generating a macro which will move rows from one tab to another.
I've created an example sheet and I want to move all rows in column E which are "Paid" from the Tracker tab to the Paid tab.
Ideally (for filtering purposes), there should not be any blank rows left in the Tracker tab.
Appreciate your help.

HI,

I will get back to with solution.

Thanks - Naveed

Hi,

U need macro or else excel function bcz this queries can resolve in two ways with macro as well as with excel function.

which one do you want ?

Thanks - Naveed.

Hi,
I was looking at a macro, however if there is an excel funtion that dooes the same I would be interested.
Personally I could live with manually cutting and pasting into the new tab, however I want this set up for someone to make it easier to transfer and less likely to lose data.

Please Login or Register  to view this content.

Ok,

one more thing i want know is u want paid info moved to paid tab and that paid info should delete from tracker tab or else paid info should show in tracker tab.

Mark

Right click on sheet (“Tracker”)-View code-Copy and paste this code, so it will reside on the tracker sheet.
Whenever you change the status in column E of tracker sheet, entire row of that row will be copied in to paid sheet. All automatic. On the above code, I commented this line 'Target.EntireRow.Delete
If wish to delete once the invoice has been paid, you need to remove the comment, so the row will be deleted from the tracker sheet

I want the Tracker tab to be clear of paid items once the macro has completed.
The requirement is to move from one tab to the other.

This is exactly what my code does. It deletes the row once the invoice is being paid. If you wish just to clear the row.

Change this line

Please Login or Register  to view this content.

in to

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Many thanks, the bolow works perfectly.
I notice that you have to ensure there are no grouped columns in the trasker spreadsheet, but does what was asked on the tin.

One again, many thanks

Originally Posted by AB33

Please Login or Register  to view this content.

Hi AB33 Sir,

Thanks this is one very nice i don't we can use in this way also thanks u so much sir definetly i will work on this code.

Ken
Glad it has worked for you!
Raza! Yes, it cuts out labourous work