Vba for conditional copy and paste

[rikk1965]

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

[jmac1947]

hello rikk1965

it always helps if you attach a sample workbook, often you get completed code right back in the workbook. Most of us work better with a "smaple workbook" in front of us

Jmac1947