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
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