Copy only rows with data to second sheet, delete from first sheet

I have a client list that I'd like for our Account Managers to be able to use to keep a running log of client contact.

I've looked through the Forum and haven't been able to find exactly what I'm looking for. And as I'm Visual Basic deficient I've been unable to piece meal it together.

What I am trying to do is capture information on sheet "Client Information" in Columns A, B, O, P, Q, R, and S but only if there is information in P, Q, R, and S. I need this info populated on a second sheet named "Client Log." Once copied I need Columns P, Q, R, and S cleared from sheet "Client Information" so it's clear for the next input.

I'm not sure it matters but our current client list is 250 and growing. If possible I'm looking for code that can grow with our client base.

Thank you in advance,

Antonio "The Visual Basic Deficient" (I need a cape!)

Your request is not clear as using OR and AND will give you different results. I assumed OR, that if any columns P-S are not empty.

Hi Monotono,

Welcome to the forum

Here's a VBA solution:

Please Login or Register  to view this content.

Directions for running the routine(s) just supplied

Copy the code to the clipboard

Open your Workbook

Save your Workbook or Another Workbook designated for Macros as Macro_Enabled

Press ALT + F11 to open the Visual Basic Editor.

Select “Module” from the Insert menu

Type "Option Explicit" then paste the code under it

With the cursor between Sub and End Sub press F5 (F8 to Single Step)

OR

Press ALT + Q to close the code window.

Press ALT + F8 then double click on the macro name

Hi Tonomono,

Thanks for the rep, but I'm deleting the whole record from the first sheet. If you only want the four fields deleted then change:

Please Login or Register  to view this content.

To:

Please Login or Register  to view this content.

Button on sheet client.

And (continued):

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

Here:

Please Login or Register  to view this content.

You're welcome and thanks for the reps!