Thread: VBA Code to Cut and Paste rows of data depending on criteria

Hi,
I have a worksheet with a a bunch of filtered data. I want to have each record (row) of data cut and pasted into a new worksheet if the value of the record in column O equals "Complete".

- The data begins in row 9

Please advise if any other details are required.

Hi, Could you brief me on this.. bcoz i have a doubt ... why can't you filter the col D says complete and copy and paste the entire to new sheet

I guess that could work...Is is possible to select only visible data, cut it, and then paste it?
Then remove all blank rows?

Im pretty new to vba here, and haven't had alot of time to prepare myself, kinda just thrown in on this project....if you have any coding that could get me started it would be greatly appreciated!

Hi,

I'm new to this forum and have ZERO knowledge about coding but I think my proclem could be solved with VBA coding only.

I've over 18000 records in a sheet. All records have columns assigned to them e.g. clinic name, patient name, insurance, DOS, aging days and balance etc. Most of the patients are appearing more than once.

1. I want to subtotal for all the records for each patient
2. A new column added is total balance for patient.
3.I need to merge this new column for patient for each records and then put the total balance into that column.

I successfully get totals using subtotal but can't auto merge the cells and put total there.

Below is the sequence of the columns.


PracticeName InsuranceCarrierName PatientName MRN DOS Aged Balance Subtotal

I've attached a sample data sheet for review.

thanks

pravin...