VBA Help

[Scott Halper]

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

 

[Bernie Deitrick]

Scott,

Don't do that - having multiple copies of data is a recipe for disaster. Use data filters instead,
on one sheet, and select the region, name, or amount criteria on which to filter/show your data.
Then when you delete a row of data, there is no concern about synchronization.

HTH,
Bernie
MS Excel MVP