I'm not an excellant VBA programmer and am looking for help.

I have a bunch of data that looks like this:

Name Region Sales
Joe Smith East 1,000
Jane Smith South (blank)

What I am looking to do is when the sales field is populated with a
number, to take that row and then copy it to the first 10 rows of the
spreadsheet and then when a number is deleted from the sales colum,
the row that has been copy above is then deleted.

Thanks for the help.

Scott