If blank copy cell

[coastguard]

I am looking for some help? I would like to be able to look for blank cells and if blank copy the information in an adjacent cell to another sheet for example:

................A..................B..................C
...............Names.......Date joined......Date left
1.............John..........01/05/05..........23/09/06
2.............Paul..........10/04/05
3.............Ann...........15/06/06..........17/09/06
4.............James........24/07/05..........30/09/06
5.............Peter.........14/08/05
6.............Colin..........25/06/05.........18/09/06
I would like to be able to copy A2 and A5 to a new sheet if the dates in C are blank, is this possible?

many thanks

 

[Smitty]

Welcome to the Board!

You can goto Data-->Filter-->AutoFilter-->Filter column C-->Select the Blanks option.

Then you can copy the blank rows to another sheet.

Or did you want an automated method (VBA)?

Hope that helps,

Smitty

 

[coastguard]

I was hoping that it would be automated cheers

 

[Smitty]

I was hoping that it would be automated

Based on what criteria?

What will trigger the copy?

Smitty