PDA

View Full Version : Cut&Paste to another Worksheet Based on Cell Value



laurah
08-25-2011, 02:41 PM
I have been trying to figure out what code for a macro I need to use to cut and paste an entire row if Column A has the word "Client" on the tab "P Reporting" to my second worksheet ("Client Reporting"). It should begin in Row 2, just below the headers already on the Client Reporting tab. They then need to be removed from the original tab, either by delete or cut.

This is a shortened version of my spreadsheet, it has close to 20,000 rows and several columns.


REPORTINGNamePCompany APCompany BPCompany CCLIENTCompany OCLIENTCompany PCLIENTCompany Q

parttime_guy
08-27-2011, 04:36 AM
Hi laurah,

Similar Problem (Solved)

Kindly download file and see the Instructions flap

Hope this helps !!!

Best regards