Could someone help?
I need vba in a command button to do the following.

On sheet 1 look in range 'work' and copy only cells that have anything in them and paste them to sheet 2

Any help would be great