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