VBA Help

[mallen83]

I am in need of a macro that will do the following.

Dialog(Sheet1)

Customer Date Comment Employee
John Doe 5/17/11 Needs to make a deposit MSA

I want it to take and copy this information from the Dialog Sheet, to a sheet with the customers name after hitting a submit button, then erase the information.

On each sheet I have Date, Comment, and Employee columns and want it to go to the sheet based on the Customer name in A2, to the Sheet named after that customer.

Hope that makes sense and someone can help me out.

Thanks!

 

[texasalynn]

this would need to be changed
If WorksheetFunction.CountA(Range("A2:C2")) <> 3 Then
to
If WorksheetFunction.CountA(Range("A2:D2")) <> 4 Then

 

[mallen83]

That worked wonderfully thank you so much.

 

[mallen83]

Alright it works really well except it is clearing out my drop down menu as well, I can make the change to not clear that specific cell, but is there a way to erase just the text and not the whole list?

 

[texasalynn]

change the clear to this

Range("A2:D2").ClearContents

 

[mallen83]

Thank you

Last one I hope.

Automactially enter the date and time once I have choosen a name from the drop down menu, and of course change that time each time a new name is selected.

Your amazing!