VBA Help
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
|