Move data from 1 sheet to another

[Joe V]

I need to move info from spreadsheet to another seperate sheet - I would like
to know if you can can just make a check mark in a specific cell and when you
hit enter the line item moves to another sheet - Say like on a accounts
receivable ageing report when an invoice is paid you can check it and it will
automatically move to say a paid invoice sheet

 

[xl_prog]

IMHO, run your macro AFTER you've marked cells adjacent to items you want
to move to a different worksheet.

You'll need to create the new sheet, keep track of what the most recent row
you've
posted to (so that new entries post one row below previous entry) and then
go back
and iterate over the source range again, deleting the ENTIRE ROW where there's
a check mark in the 'move this item' column.

I suggest doing these as two separate passes. It will make your coding much
easier. Deleting rows and keeping the loop counter in sync can be a headache.

You'll also want to know what the last row in the column your iterating
over. There are many methods, all well posted on the web. Familiarize
yourself with the CurrentRegion and the UsedRange.